| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a warning message on a command button
I am a newbie to anything above basic level in Excel. I know how to create
and use Command Buttons, but I need to create a "Warning! Are You Sure" message when you click the button, with "Yes", "No", and "Cancel" options. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a warning message on a command button
The code is
MsgBox "Warning! Are You Sure", vbYesNoCancel But you'll want it to be part of a conditional statement, for example If MsgBox("Warning! Are You Sure", vbYesNoCancel) = vbYes Then Exit Sub End If HTH On Jan 23, 4:13*am, lkreeder wrote: I am a newbie to anything above basic level in Excel. *I know how to create and use Command Buttons, but I need to create a "Warning! Are You Sure" message when you click the button, with "Yes", "No", and "Cancel" options.. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a warning message on a command button
JP has given you an answer which should get you started. However, I have a
question... what is the difference between the user answering No and them answering Cancel? -- Rick (MVP - Excel) "lkreeder" wrote in message ... I am a newbie to anything above basic level in Excel. I know how to create and use Command Buttons, but I need to create a "Warning! Are You Sure" message when you click the button, with "Yes", "No", and "Cancel" options. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a warning message on a command button
Thanks, JP. Worked like a charm. Maybe I need to buy one of those thick books
to learn this stuff..... "JP" wrote: The code is MsgBox "Warning! Are You Sure", vbYesNoCancel But you'll want it to be part of a conditional statement, for example If MsgBox("Warning! Are You Sure", vbYesNoCancel) = vbYes Then Exit Sub End If HTH On Jan 23, 4:13 am, lkreeder wrote: I am a newbie to anything above basic level in Excel. I know how to create and use Command Buttons, but I need to create a "Warning! Are You Sure" message when you click the button, with "Yes", "No", and "Cancel" options.. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a warning message on a command button
Glad to hear it, but I think I actually typed it wrong, it should be
If MsgBox("Warning! Are You Sure", vbYesNo) = vbNo Then Exit Sub End If because you want to exit if the user clicks "No". Also I agree with Rick that No and Cancel basically mean the same thing, so Cancel is unnecessary. HTH On Jan 24, 4:04*am, lkreeder wrote: Thanks, JP. Worked like a charm. Maybe I need to buy one of those thick books to learn this stuff..... "JP" wrote: The code is MsgBox "Warning! Are You Sure", vbYesNoCancel But you'll want it to be part of a conditional statement, for example If MsgBox("Warning! Are You Sure", vbYesNoCancel) = vbYes Then * Exit Sub End If |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| how to create attachment command button | Excel Discussion (Misc queries) | |||
| How to create a link by using command button in VB | Excel Discussion (Misc queries) | |||
| How to create command button to save the dates and time | Excel Discussion (Misc queries) | |||
| How to Create a Command Button | Excel Discussion (Misc queries) | |||
Linear Mode
