ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to: Assign pop up when command button is pushed (https://www.excelbanter.com/excel-programming/378293-how-assign-pop-up-when-command-button-pushed.html)

Sara Stone

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!

Corey

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....

"Sara Stone" wrote in message
...
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!





All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com