How to: Assign pop up when command button is pushed  
Author Message
meredit





PostPosted: Mon Nov 27 18:22:58 CST 2006 Top

Excel Programming >> How to: Assign pop up when command button is pushed

Hello,

Does anyone know how to assign a pop up message when a command button is
pushed? I'm trying to create a form that has help buttons and when one of
the help buttons is pushed by a user I need a pop up (or something like it)
to come up and say a specific message.

Please help. Thanks!

Excel198  
 
 
Corey





PostPosted: Mon Nov 27 18:22:58 CST 2006 Top

Excel Programming >> How to: Assign pop up when command button is pushed sub msg()
msgbox "This is the message",, "Title Box" ' <====== Modify to suit
end sub

You can use the :
call msg to run the msgbox


Or alternately

in design mode double click the command button you want to run the message,
then place the code there.

Corey....



> Hello,
>
> Does anyone know how to assign a pop up message when a command button is
> pushed? I'm trying to create a form that has help buttons and when one of
> the help buttons is pushed by a user I need a pop up (or something like
> it)
> to come up and say a specific message.
>
> Please help. Thanks!