This has probablly been answered before but does anyone have any sample code
show how I would go about moving the locaiton of a combo box dependent on
where the user clicks. I  know it's probablly going to involve the
SelectionChange event of the worksheet but I can't seem to get ...

When I drag a form over my screen it remains visible at the place wher it
left. So, if I drag the form 5 times, I see 5 forms on my screen. How can I
avoid that?

Hello I'm just wondering if anyone has some good links to tutorials on using
WinAPI calls, I've used some of them but I don't really understand what's
going on. It'd be nice to work through some tutorials suited for VBA + WinAPI.
Thanks for any information in advance.

I want to create a worksheet with Staff dates of birth and get a notification
(column on worksheet blinking in any colour) 3 days to the staff's birthday
date whenever i put on my system

I have two HLOOKUP formulae and both are returning an NA value:
a) =HLOOKUP(E$2,'FY09 Monthly'!D2:BL147,$A5,0)
and
b) HLOOKUP(E$2,TestNameRange,$A5,0)

Running this code
   Sub test()
       For i = 1.5 To 2 Step 0.1
           Debug.Print i

I Have recently installed Excel 2007 and some code that worked on previous
versions now does not work.
I am trying to create a button with 3 lines of text using the following code:
   ActiveSheet.Buttons.Add(23.25, 17.25, 209.25, 87).Select

Could anyone please let me know how would I programmically to change all
cells with red fonts to italics and underline them from cell A2 through Q
with variable rows?
Thanks in advance.

Using Excel 2003.  Thanks in advance for the formula to
COUNTIF(F2:F2121,"ABC"" AND (L2:L2121 = "DEF"))??  How can you compare
row-by-row using an and condition vs. going thru the entire column?  In other
words, does a row have ABD and DEF simulataneously in 2 separate columns vs ...

Hi experts,
using Excel '03...
My company is trying to save its xls documents (and other MS docs) in
a particular format; e.g., Program_Desc_Date_Initials.

Is there a way to specify which tab is active when a workbook opens? I'd like
to have one of our custom tabs be the active tab.
Thanks, Larry

I've created a custom tab with buttons for my custom macros but i can't seem
to get the macros to work. When i press the button i get the following error:
"Wrong number of arguments or invalid property assignment". Yet, if i go to
View Macros and click run the macros work. Any ...

Dear Sir,
I have a ZoneWise Worksheet i;e
nz01,nz02,nz03.wz01,wz02,wz03,sz01,sz02,sz03 and so on.
Now i want to copy this data according to ZoneWise For example: nz01

Did microsoft not expect anyone to use the bottom rows of a
spreadsheet? I was given a file with about 120,000 records. Normally I
would load this into Access for analysis, but I was giving this data
to someone not familiar with Access and so I loaded them into Excel

I'm trying to do a macro VBA for that:
There is a range in a sheet that I don't know how many rows it has.
I want to copy cells from column D to column C (for example), but only in
the range, becouse there's another data in this D and C columns out of the