Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro completed message
This is probably pretty simple, but I need some help with it. I have 3 macros
run by clicking on 3 buttons. I need to have a short message after each macro is run that says 'Done!. So when the user sees the 'Done!' message they can then click on the 2nd button, and so forth. Thanks. -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro completed message
If the user doesn't need to do anything between steps, you could have one macro
that calls all three procedures: Option Explicit Sub DoThemAll() call macro1 call macro2 call macro3 End sub Or if they sometimes have to do things between procedures and sometimes not, you could add a 4th button that calls all 3. EZ wrote: This is probably pretty simple, but I need some help with it. I have 3 macros run by clicking on 3 buttons. I need to have a short message after each macro is run that says 'Done!. So when the user sees the 'Done!' message they can then click on the 2nd button, and so forth. Thanks. -- -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro completed message
Thanks Dave. I will consider your suggestions. -- when u change the way u look @ things, the things u look at change. "Dave Peterson" wrote: If the user doesn't need to do anything between steps, you could have one macro that calls all three procedures: Option Explicit Sub DoThemAll() call macro1 call macro2 call macro3 End sub Or if they sometimes have to do things between procedures and sometimes not, you could add a 4th button that calls all 3. EZ wrote: This is probably pretty simple, but I need some help with it. I have 3 macros run by clicking on 3 buttons. I need to have a short message after each macro is run that says 'Done!. So when the user sees the 'Done!' message they can then click on the 2nd button, and so forth. Thanks. -- -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro completed message
"Jim Cone" wrote: Check out the MsgBox function in VBA help... ** I will visit the help menu, before having you exert the effort to answer my question. Msgbox "Specify the Excel version you are using_Done 1" ** Not sure if the version will make any difference for this question Msgbox "Post the appropriate parts of your code_Done2 ** I don't think this relevant. Because I need the msg at the end of my code! Msgbox "Respond to those who took the time to answer_Done3" ** I always thanks those who help me as well as those who try. Check out my replies to Jacob and Dave... they did actually HELP. -- Jim Cone Portland, Oregon USA "EZ" wrote in message This is probably pretty simple, but I need some help with it. I have 3 macros run by clicking on 3 buttons. I need to have a short message after each macro is run that says 'Done!. So when the user sees the 'Done!' message they can then click on the 2nd button, and so forth. Thanks. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF completed THEN invisible | Excel Discussion (Misc queries) | |||
% completed box | Excel Programming | |||
Has anyone ever encountered an error AFTER the macro has completed | Excel Programming | |||
Prompt to say complete when macro hasd completed task | Excel Programming | |||
how to add message box after a macro is completed | Excel Programming |