Thread: MsgBox Help!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nicke[_4_] Nicke[_4_] is offline
external usenet poster
 
Posts: 7
Default MsgBox Help!

Hi,

It think you'll have to pass a parameter to every macro
that tells the macro what to do. You could make the
parameter Optional, i.e.

Public Sub MySub(Optional ShowMsg as boolean = True)
'In this case ShowMsg = True if no parameter was given
'Your code...

If ShowMsg Then
msgbox "Updated!"
End If


End Sub

Hope this help!

/Nicke
-----Original Message-----

Hi,

I consider myself an Excel formula expert, but only

slightly above the
novice level in VBA macros. Here's my problem.

I have a workbook where I've written about 30 different

retrieve macros
(Hyperion Essbase) to update data in different sections

of the file.
At the end of each macro I have a msgbox that basicall

says "data
updated". This is fine for running the macros

individually.

I'm now writing a macro that will call and run all of

the other ones in
a specific order. I don't want the user to have to

click OK 30 times
in order for the macro to continue.

Is there a way to make it automatically clear each box

and continue.
Obviously I could take the msgboxs off of the end of

each individual
macro and it would work, but I'd really like to keep

them their.


Any suggestions?

Thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from

http://www.ExcelForum.com/

.