I have this code below, in which I am trying to format cells with different
formats, is there a way of shortening this and maybe the change will make it
run faster.
These are sub heading that are suppose to be printed per produt info.

I write vba code for combo box.
formCombo.CmbDate.RowSource = "SELECT DISTINCT pp FROM SS ORDER BY
pp;"
but it doesn't work!

I am looking for a sort of drill down reporting feature.
I have two workbooks. WB1 and Wb2.
Wb1 has cells with red or green color based on some criteria.
When clikced on any particular red cell, it should open Wb2 and show only

I'm having trouble changing the properties of objects permanently at
runtime. Specifically, I am trying to make a commandbutton visible at
runtime. This works fine, but when I reset the VBA code, the
commandbutton returns to it's state prior to running the code.

Can anyone tell me how to create a toggle button in a Toolbar in Excel
VBA?
Thanks,
Amit

I need an if formulae in a2 that says if cell a1 contains the word
"procedure" then put "x", if not put a "y".
ie an x would be the result if cell a1 stated:
"this is the procedure", or

In essence I would like to display the content of my excel work book in a
user form in Visual Basic. Can anybody please give me some advice on how to
achieve this. Be as detailed as possible since I am still very new at Visual
Basic.

I have 300 numbers and 1 number. I want to know whether that 1 number
is the sum of the combination of those 300 numbers and which several
numbers in these 300 numbers sum up to produce that 1 number.  Some of
these 300 numbers are same.  Can I use Excel to work out that question?

i have following code:
'----------------------------------------------------------
Dim WRDAPP As Word.Application
Dim WRDDOC As Word.Document

Suppose I create a dropdown as following:
 Set drp = ActiveWorkbook.Sheets("Sheet1").DropDowns("GroupBy")
   drp.RemoveAllItems
   drp.AddItem "Group By", 232

I have a somewhat complicated workbook that I would like to create, but
I'm not sure if it's even possible with excel.  Some people on this board
were kind enough to answer some questions for me in the past, so I
thought this might be a good place to start.

Excel 5.0 was my introduction to VBA when the old DOS Macro functions were on
the way out.  I learned to program in VBA by using the help files that were
available with the XL 5 in Windows95.  The help files were user friendly
enough to explain the dos and don'ts when using the ...

I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the
word..."honda" anywhere within the text, etc., etc.
I was explained this yesterday...
HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS??

Hi, it was suggested that I try the Excel VBA forum regarding this issue:
Does anyone have experience with the calendar control (ver. 8 for Office
XP)?  
If I have to download mscal.ocx to a computer and register it (necessary

On my Userform, I am using the listbox to populate it with files from a
directory.  What I am trying to do is open the files and merge them into a
single file. I appreciate any help anyone can give me.