This seems like it was going to be easy but I can't figure this out.  I want
the user to be able to select an action with a SINGLE-CLICK from listbox1,
perform the action, and "reset" the selection to listindex=-1 so that the
same action can be selected again if desired.  I am ...

what is wrong with this one... noob question
Sheets("CP").Range("a5") = "=Updated on " & Now
Thanks for the help

I have about 60 CSV files that get created by another application.  I would
like to take all those files and combine them into a single Excel workbook --
each CSV file becoming a worksheet therein....
Help?!     Thanks

How would I write the code to delete a row depending on if a certain cell is
blank?
If e1 is blank delete row 1 and so on.
range("C").Select

I try to run an SQL query in VBA code, to perform a query on an Excel
table and have the result added as an Excel table in the same sheet (to
range j1). (see code below) The SELECT statement comes into the
variable strQuery.

In a form I like to force the cursor to start in textbox1 because when I
open the form now it starts with the cursor in textbox2.
Private Sub CommandButton3_Click()
On Error Resume Next

Although Excel provides Database processing (DSUM etc) it does so with
"external" criteria - "external" meaning that they are defined in cells
outside the Database function.
I have seen posts that process ranges with really complex criteria defined

1
2
3
4

I want to offer user with a window containing names of the months in a
year seperately on each line.
The user would choose one of the 12 and press something like ok and I
want the month chosen by the user to be stored in a variable in my

Hello - I have had luck loading xml files using the following declaration and
assignment in the sub routine:
   Set xmlDoc = CreateObject("Microsoft.XMLDOM")
   xmlDoc.async = "false"

I have quiet a few dropdown boxes on my w/s (combo boxes, 56 in all!),
i have assigned named ranges for the data in each box but i have not
done anything with linked cell (as i dont know what this does) what i
would like to do is click my command button and have all dropdown box

I have a subscriber email address list of over 20,000 Email addresses.
I would like to be able to click a button on a sheet and a dialogue box
appear displaying an
Email address which has been randomly selected from the list.  Is this

for ComboBox change
Condition 1: if old content = new selected ComboxBox.item -> do
nothing
Condition 2: if old content <> new selected ComboxBox.item -> change

I have attempted to create a macro that will - for each selection under
auto-filter in column A9 - post the corresponding information for 'the
selection' and copy and paste it into a template on another workbook
then save it.

    Hi all,
Thanks in advance for taking the time to read this and help a newbie
to the world of expanded worksheets (beats moving to D and
manipulating in ASP, but you gotta do what your three brain cells will