[Sorry, I mistakenly posted this to the functions group. I meant to
post it here]
What is the best method to validate a string's existance in a CLOSED
workbook that has many filled cells?

I created a macro in excel that has a shortcut assigned activating it,
Ctrl+Shift+A.
Macro runs fine when it is invoked using Menu: Tools\Macros\...\Run.
But when I use a shortcut it never finishes just dies.

Programming is not my forte, so apologies for stating the obvious.
I want to code so that on selecting an option in a combo box, the cell to
the right of the combo box returns the current user's name, and then the date
the next cell along.

I have a workbook with three worksheets (INTRO, ORDER, ITEMS).  The meat of
the workbook is with Orders, and I have everything working correctly on that
sheet.  However, I need a userform that is used on ORDERS to be displayed on
INTRO when the workbook is opened or when the ...

Does anyone know how to stop the following message appearing while
running a macro?
Microsoft Office Excel is waiting for another application to complete
an OLE action

When the mouse hovers over a toolbar button the 'Name' appears.
I frequently use a basic shape (Bevel), assigned to run a macro, on a
worksheet.
Although my bevel shapes have a brief descriptive word on each, it would be

i want to add 1 to b74 each time any cell b4-b54 is equal to "Y".

I want my user to enter a time into an input box and store the value in
a date variable. Here's my code:
Dim MyTime As Date
MyTime = InputBox("Enter Time", "Time", Format(Time, "hhmm")) / 2400

I am trying to force closure of an Excel 2003 workbook via VBA behind a user
form rather than with the normal File | Close or X and have tried several
different approaches; none of which solves the problem.  When the user form
is hidden, the File | Save and X close options are ...

In a pice of code I found this expression.
Case Is < 2000000000000#
Wath means an what is the function of  "#"
Regards,

I have a multipage on a userfrom with 92 optionbuttons.  I would like
to change the names from OptionButton1 to opt1.  I have seen posts
that includes loops to rename controls but i can find it at the
moment.  Any help is appreciated.

Can someone please help me with VB code for the following process:
I have a list of items in column A (a database query linked to Access
table). The items are highlighted in different colors by the end-user.
When I refresh the database query the next day, the colors move around

At present I have a formula that counts the number of date entries in
a column.
=COUNT($AL$1000:$AL$5000,"<=today()")
I need to change it so that it counts the dates between today and the

I have a spreadsheet that uses extensively OFFSET(INDIRECT(cell),0,0,1,1))
where cell refers to a cell containing a XLS name because the filename and
path change monthly. When I open the main file all my cells containing the
above formula show "#REF" until the spreadsheets it's ...

here is the code from a recorded macro:
the items in caps are what i entered afterwards.
DATATABLE is a named range
what does not to be working is the  [TableDestination:="ROLLUP!A4] part.