Programming

trouble using checkbox26_DblClick
I am trying to doubleclick checkbox26 and make value of cell D10 = "N/A" as well as clear tick in checkbox26. But then if the user later wants to go back and single click checkbox26 I need to clear the "N/A" and have the checkbox operate as normal. Here's what I have: Private Sub CheckBox26_Click() Ran... 4 May 2010 14:35

SUMIF criteria
I have a spreadsheet and I am running a SUMIF to a second and I am having trouble with the search criteria. The original reference is a 3 or 4 digit number and the criteria I am searching for has a text discriptor in front of that 3 or 4 digit number. Is there a way to have the SumIf formula figure out that I a... 4 May 2010 14:35

Using the FIND function in a loop
Hello, I have two worksheet x and y. x - Column C 1 2 3 4 5 y - Column C 1 1 2 3 2 1 1 I am trying to use the FIND function to traverse through y - Column C and return the row value of the match in x - Column C to y - Column D. Here is what I have so far. Note that it fails with the following ... 4 May 2010 13:29

Z order problems
I run Excel 2003, Windows Vista and Internet Explorer 8. I have a macro which quietly drives Internet Explorer. When the macro has been waiting for a long time for a response from IE, it does IE.Visible = True so the user can see what is happening and displays a message for a short time with Set sh = CreateO... 4 May 2010 12:21

Range References in vba
I have 2 named cells say, tStart and tEnd - If I wanted to set the contents of all cells within the Range("tStart:tEnd") I thought I could do something like the following; Sheet4.Range("tStart:tEnd").Value = "Temp" but that givs me a '400' type error - what would the way be to reference these cells. On a... 4 May 2010 13:29

To attach file to a workbook in a addin.
I want to attach a file to the workbook or an addin. The file may be a picture file that is some special logo that is part of the excel or some other dll file needed to run the addin Like we insert the new form from one workbook to another is it possible to insert files on non excel type. *.jpg,*.gif,*.dll or som... 4 May 2010 03:33

Drop down-list translation
I run Excel 2003 on Windows Vista. I want to drive an HTML page with the following excerpt: <select id="title" name="title" tabindex='0' onfocus='rememberMyFocus(" title");'> <option value="">-- Please select --</option> <option value="0001">Ms</option> <option value="0002">Mr</option> ... 4 May 2010 12:21

how can i apply a footer in every .exl file
plz give me solution for this question ... 4 May 2010 09:00

Save excel sheet as html then save to web useing ftp
I want to record a macro that will save a excel sheet as a html file in a ftp:// location. I would expect it to open the log-in box for user name and password which is fine, but I can get it to even try and make the connection. ... 4 May 2010 00:16

running Excel 2007 macro in Win7
I have a co-worker who uses macros that I write for him who has recently upgraded to Win7 and now he is not able to enable the macro to run, I think due to security settings. This user will open the Excel file (using Excel 2007) which is located on a sharepoint (also 2007) and will click on the command button but... 4 May 2010 02:27