How can I open a file with multiple sheets and have a formula or code return
the names of the sheets so i can perform calculations on varying sheets with
out manually having to input them into my formulas.
Example: i open a file created by anouther user that has 7 or 8 sheets with ...

I am taking the data from a userform to a comment on the cell the is
currently active.  I am running into some errors using the following code
close to the end where the data is concantenated.  What I need to do is a
carriage return....I thought that might be CHAR(10) within the ...

Is there a way to add an item (Macro) to the right cleick menu? The macro
will be calling a userform.
Any help would be appreciated!

What does:
IF(COUNTIF(D2,"*Honda*"),"Honda",D2)
this formula do??
i.e. what do the *______* accomplish??

Here is my problem,
I have rain gage data at varying time intervals with a cumulative
precip. amount at that time interval making a 2-d array. For example
10:00  1

I'm new with Forums and Newsgroups
I've already posted this question in MSDN Forums » Microsoft ISV Community
Center Forums » Visual Basic for Applications (VBA). But I found this morning
that Newsgroups should be a better place for my subject.

lets assume i have inserted a form into my excel workbook
i put in a frame, one textbox, one combobox and one commandbutton. I want
the commandbutton to remain greyed out, so i put the property for enabled to
false. i need to have the enabled property to change back to true when ...

Not exactly an excel question but thought you maybe able to help.
I currently have an excel speadsheet that has a link to SQL server.  I am
the only person that has access to SQL.  SQL updates the tables at 1 am
everyday.  To update the spreadsheet I have to open the file, refresh ...

Hello Experts
This is from help - modified slightly -
Function Test(theField, Range)
Dim c, firstAddress

I need a way to run a command in the CMD window and retrieve the output back
into Excel.  Is there a way to do this?
For example if my output below is in the CMD window I want to capture the
Items starting with DEVA.

I am loading dates into a dynamic array and am getting error message, "run
time error 9, subscript out of range" the dates on the spreadsheet are
formatted as date and look like 2/5/2005 in the formula bar, I tried using
DateValue and DateSerial Function, no help.   Stepping ...

Hey--Is there any way to permanently select certain references from the
VB Project library? I want to be able to always reference microsoft
word at all times in VB, rather than have my users tell the VB editor
that they would like to reference word...

Does anyone out there know how to take a string from excel, or a VBA
variable and insert it into a field on a web page?  I am trying to log
into a web page automatically.  I have even gone so far as to create my
own stupid web browser in VBA but am stumped as to how to do this.

This The expression works OK:-
Set VBComp = ThisWorkbook.VBProject.VBComponents("Sheet1")
But what is the correct syntax if I want to refer to a sheet with a variable
number?

hi,
I have some rectangle autoshapes in my spreadsheet that are transparent.  
Although it looks cool, users cannot click on the cells behind it, so I have
been requested to get rid of the transparent autoshapes.  Can anyone ell me