I'd like to create my own number formatting buttons, similar to the '$' '%'
and ',' buttons that exist in Excel.
Can anyone point me in the right direction?
Thanks.

in the following code, line 232 (the save line that is called after the loop)
errors and kills the program. this is causing another error later on when i
call this again.
Does anyone know why this is or have suggestions on how to fix it?

I have a file named Schedule Master.xls in which I manipulate and save as a
name+date.xls.  When I open the Schedule Master, I have code to automatically
import a new set of data.  However, if I need to open my name+date.xls files
in the future, I want to use the data already ...

I developed an Excel Addin over the last several years (requirements
creep).  It has about 10 shortcut keys.  The shortcut keys have worked
in Excel 2000 and Excel 2003.   Currently all users of the app use
Excel 2003.  The app I have has grown in size over the years.  It has

How do I do the following?
I want to convert text to a number but skip the blanks in a range
this is what I have, but it debugs because I have blanks
Range("C2").select

How do you link a Macro to a CommandButton.
Right now when I click on the button in design mode it references a
macro on the worksheet I am working on and it is trying to reference
another Macro.  The macro is stored in a different file in another

i have a template made up and that part works and looks good.  i need a macro
that not print unless the value is true.  (ex. if the value in cell a1 = bbb,
it will not print indicating an error on the worksheet.
thank you,

Hi! I have macros that on a worksheet that run off data on worksheets, in the
same workbook, that need to be hidden when the workbook is distributed.
Whenever I hide them my macros Iget runtime error '1004' Select method of
worksheet class failed.

Hi, Sorry to ask again. Im asigning values to a vba static array, when
I got 100 values, is there a way to calculate the average of the last
50 values, then if I add further values, Iwant to average only the last
50 added.

I'd like to add some interactive console functionality to Excel.  While
not essential, having a dockable window would be a "cool" feature to
have.  Has anyone heard of this being done (or possible)?

I assigned a shortcut key to an Excel macro, but it is running totally
weird. I mean, I can run the macro from the VB editor screen using the
F5 function - it runs perfect, but when I try the short cut key, it
runs halfway into the program and then comes to a dead stop, and an

I am trying to write a formula in Excel that tells whether 4 cells in the
same row have the same value. The IF function is limited to 2 cells.

Is there anyway to control what's diplayed in the combobox while not
selected? Example. A search combo would display "Search..." until it
gets activated, which it would then drop down the selectable values.
Thanks.

Hey,
I have a large range of cells that I would like to be able to sor
descending by one of the columns.
Is it possible to do this using vba? I have looked into the bubblesor

I'm in Cell AA25: and need to access the data in cell O25 in a way that IF
cell O25: =1 then insert $130.00 or IF cell O25: =2 then insert $240.00 or
if O25: is blank leave AA25 blank. Any assistance is greatly appreciated.