Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
While executing a macro, I want to first show a form or message box
providing information to the user and allow continuation or cancellation of the macro dependent upon the user's decision. I've got the macro built and functioning but I'm unsure of the best way to execute this additional step. Thanks for the help. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
a yes/no message box inclosed in an if statement might work. If MsgBox("entery message here", vbyesno) = vbYes Then Exit Sub End If if the user select yes, code stops otherwise it will continue. regards FSt1 "cagey63" wrote: While executing a macro, I want to first show a form or message box providing information to the user and allow continuation or cancellation of the macro dependent upon the user's decision. I've got the macro built and functioning but I'm unsure of the best way to execute this additional step. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Dialog Box | Excel Discussion (Misc queries) | |||
Assign Macro Dialog Box | Excel Discussion (Misc queries) | |||
How do i get the print dialog box to appear in a macro? Help!!! | Excel Programming | |||
control of dialog macro dialog box. on open | Excel Programming | |||
Macro Dialog Box Help | Excel Programming |