| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a dialogue box pop up with a notice to user?
I need to have a dialogue box come up with a note to the user when certain
conditions apply. I know how to create a macro that will run when the conditions apply, I just don't know how to create the dialogue box that will appear. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I make a dialogue box pop up with a notice to user?
Hi Carl,
'============= Public Sub Tester() MsgBox Prompt:="Your message", _ Buttons:=vbInformation, _ Title:="MESSAGE" End Sub '<<============= --- Regards, Norman "Carl" wrote in message ... I need to have a dialogue box come up with a note to the user when certain conditions apply. I know how to create a macro that will run when the conditions apply, I just don't know how to create the dialogue box that will appear. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I make a dialogue box pop up with a notice to user?
Thanks! Worked perfectly!
"Norman Jones" wrote: Hi Carl, '============= Public Sub Tester() MsgBox Prompt:="Your message", _ Buttons:=vbInformation, _ Title:="MESSAGE" End Sub '<<============= --- Regards, Norman "Carl" wrote in message ... I need to have a dialogue box come up with a note to the user when certain conditions apply. I know how to create a macro that will run when the conditions apply, I just don't know how to create the dialogue box that will appear. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable/Disable Macros dialogue box when user opens Excel | Excel Discussion (Misc queries) | |||
| Le dialogue de fonction d'excel appel ma fonction "user defined" | Excel Programming | |||
| User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
| User functions and the Insert-Function dialogue | Excel Programming | |||
| How to: Make user click End User License Agreement acceptance | Excel Programming | |||
Linear Mode
