Problem to solve, apologies if the answer has already been posted
elsewhere, but I couldn't find it...
I have a macro I've written for Excel 2002. Basically, the code will
capture the contents of a cell in one workbook, then look for that cell

I have a listbox that automatically generates with a list of all the states.
It is set up for option button (fmListStyleOption) and multi-select enabled.
How can I select all of the states by default, given the user to option to
remove if necessary but not need to add if they ...

In the range M5:AJ5 I identify the column as "Actual" or "Forecast".  
As I loop through the rows, I need to copy only the columns with actual data
and paste it into another worksheet.  
I was able to identify the start column and end column of the actual data,

How do I insert a wildcard in the following query?
=IF(VLOOKUP(G5,Calendar!$A:$G,7) = "*Q*",blah blah,blah blah)
Thanks
Nathan

I'm updating an Excel 2003 spreadsheet dynamically.
I set the font for the current cell I'm working with but the
results do not reflect the font name. The other attributes are correct.
I checked to see if the font name is valid and it is.

Hi All-  I've got an exit button in a user form that I want to
accomplish the following with when clicked-
1. Prompt the user to see if they want to save the form and associated
workbook.

I would like to have one or more cells change cells if a cell below = a
certain thing.
Would it be possible in a VLOOKUP to assign different cells in the column
different colors that would be linked to the cells above the VLOOKUP cell.

I'd like to know how I can show the Cell-properties dialog from within VBA?
As my sheet is protected, the cell properties-item is disabled (greyed out)
in the format-menu.  But, in a button, I could unprotect the sheet, then
show the dialog, and afterwards, protect again.  Or ...

Hello.  I have a macro In WorkbookA that Opens WoekbookB.  In WorkbookB is
an Open event module that does some stuff.
Is there any difference in having WorkbookA Open a VBScript, and have the VB
script open WorkbookB and run Macro1 in WorkbookB (thereby eliminating the

I would like to perform the following 2 tasks when someone clicks on the checkbox feature:
First is enter the word "Market" in cell G9 and
Secondly to take whatever number appears in cell G16 and have it appear in cell B9, if the check
box is not selected then to leave blank both ...

I'm creating headings dynamically in Excel and am placing a border around
each cell as it's created.
I'd like to be able to border a cell with just 1 Excel constant instead of
having to use 4 - one for each side. Since adding borders, the program has

I'm trying to loop thru all workbooks in a folder and copy the left 6 digits
of the file name from A1 to the last row with data.  When I run the code it
stops on the first workbook and does nothing???
Here's the code:

I am trying to write a macro that will perform a formula to every row that
has column A populated with an integer.  Column A will vary in the amount of
rows that are populated, so I need a macro that will perform my formula until
it reaches a cell in column A that is not ...

Is it possible to sum a range of cells based on two criteria
eg Sum of cells in Column(C) ... if Column(A)=string1 and Column(B) =
string2
Hope you can understand that

Probably something really simple but.....
I am using a form to display questions and ask for responses ("true" &
"false" on command buttons).
the form initiallises ok and the first question is displayed (populating a