Macro completed message

  • Thread starter Thread starter EZ
  • Start date Start date
E

EZ

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.
--
 
Check out the MsgBox function in VBA help...

Msgbox "Specify the Excel version you are using_Done 1"

Msgbox "Post the appropriate parts of your code_Done2

Msgbox "Respond to those who took the time to answer_Done3"
--
Jim Cone
Portland, Oregon USA




"EZ" <[email protected]>
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.
--
 
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.
 
Jim Cone said:
Check out the MsgBox function in VBA help...
Click to expand...

** 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"
Click to expand...
** Not sure if the version will make any difference for this question
Msgbox "Post the appropriate parts of your code_Done2
Click to expand...
** 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"
Click to expand...

** 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.
 
Back
Top