Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox working is Excel Macro Programming
I want a MsgBox when the macro starts with 2 buttons. If user presses OK
button, macro continues. If user presses Cancel button, macro ends. Can someone please advise how to do the same. -- Vikas Vadgama Though worth Millions: Humanity is the biggest & the best religion. Live & Let Live. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox working is Excel Macro Programming
Hi,
You could use the below Message = MsgBox("Do you want to continue?", vbOKCancel, "Continue?") If Message = vbCancel Then End ''' If OK is selected code will run through Alan -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200908/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox working is Excel Macro Programming
Sub Macro()
If MsgBox("Do you want to continue?", vbOKCancel) < vbYes Then Exit Sub 'your code continues End Sub If this post helps click Yes --------------- Jacob Skaria "Vikas Vadgama" wrote: I want a MsgBox when the macro starts with 2 buttons. If user presses OK button, macro continues. If user presses Cancel button, macro ends. Can someone please advise how to do the same. -- Vikas Vadgama Though worth Millions: Humanity is the biggest & the best religion. Live & Let Live. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Programming - Macro | Excel Programming | |||
MSGBOX not working | Excel Programming | |||
Msgbox not working | Excel Programming | |||
.XLT with user programming not working through Intranet. | Excel Programming | |||
ComboBox programming not working | Excel Programming |