Ladies and Gentlemen,
Your help please.....
I'm pretty good with excel, but have not ventured too much in to
Macros, or VBA.

In my userforms I use often ComboBoxes, with the "MatchRequired" option to
"True". Is it possible to customize the error message when someone tries to
select something that is not in the RowSource? Now I see a awfull
Excel-error.

i have a chunk of data
I  need to loop through the current range and then fill up the Multi(?)
dim'd array with the values.
i had got to -

I have 3 sheets in my workbook...sheet 1 has 2 command buttons tha
resets cells, sheet 2 has 2 command buttons that resets cells, an
sheet 3 summarizes values in sheets 1 and 2.  I would like to put
command button in sheet 3 that when clicked, clicks the command button

I'm importing many files into excel using text import wizard.  I delineate
them all exactly the same but it takes time to do it.  I was wandering if
there was a way to do it automatically with a macro, etc?  thank you for any
help

Hopefully this is an easy one...
How can I have a cell or cells selected below the currently active cell
without naming the actual coordinates?  I am trying to select the first blank
cell in a column in order to paste added data to a spreadsheet.

This is my firs post here, not sure if this is the right thread.  
have a spreadsheet that has dropdown feature. I want the value of th
drop down to populate the next blank cell.
A1 = drop down menu

how can i find the number of the last line of a sheet??
urgent, please!

I'm new to this; hopefully someone may be able to help. I have a spreadsheet
were I want to track cells that change. So, when any value within A2:A10 or
B2:B10 changes, I would like to put an "x" within the applicable row in
Column F. I've been able to find a solution to part of ...

I want to find out if a changed cell was one of a number of cells.
The cells i want to test for are B10,B15,B20,B25,B30 etc. upto B80.
I can use the IF statement with a lot of ORs to check this but surely there
is another, cleaner way to do this. Can anyone tell me how?

I'm writing a macro that opens several workbooks, transforms them and then
saves them as a text files.
The problem is that I need the same files overwritten, and when I use the
line below, I get a message saying that a file with the same name already

I want to run a macro after the cell B7 is edited... currently the cell is a
DATA>validation>list    Does it need to be a Listbox?

I have a small macro that works in Office 2003 and XP, but generates error
445 (Object doesn't support this action) in 2007. If I replace
ChartTitle.Characters.Text with ChartTitle.Text, then it works.
Here is the snip with that code.

I am trying to create a log with a hyperlink to saved data extracts from a
SQL server upon refresh of the data.  I refresh the data upon opening the
workbook, so the macro is located/written on This Workbook.  However, the log
is in another workbook.  I am having trouble setting ...

I'm trying to create a variable number (between 1 and 4) of collections, but
I don't know what that number will be in advance.  Is there a way of
creating (and declaring) collections at runtime?
So far my solution has been to declare four collections at the beginning of