PC Review


Reply
Thread Tools Rate Thread

Dialog box in a macro

 
 
cagey63
Guest
Posts: n/a
 
      11th Jan 2008
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 With Quote
 
 
 
 
FSt1
Guest
Posts: n/a
 
      11th Jan 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Dialog Box will07 Microsoft Excel Programming 7 2nd Oct 2009 12:07 AM
Macro Dialog Box cardosol Microsoft Excel Misc 1 10th May 2008 03:51 AM
Macro Dialog Box =?Utf-8?B?VGF5bG9yTGVpZ2g=?= Microsoft Access Macros 1 7th Aug 2007 06:52 PM
control of dialog macro dialog box. on open Gerry Abbott Microsoft Excel Programming 0 22nd Jul 2004 05:41 PM
Remove macro dialog after macro deletion =?Utf-8?B?RmFkcw==?= Microsoft Excel Misc 2 16th Jan 2004 01:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:58 AM.