Click message box to run macro?

Cosmos75 · Mar 26th, 2002, 10:45 AM

Is there anyway to use a message box to run macro?

MsgBox ("Click to run macro")

What about having more than one choice on the message box??

davers5 · Mar 26th, 2002, 10:58 AM

See msgbox function in vb help.

There are several optional arguments for the function.

msgbox("Would you like to run the macro?",vbyesno,"Run Macro?")

Will give you a message box with two buttons. If the person clicks yes, then the function will return the integer 7. So you need an if statement that looks like this:

If msgbox("Would you like to run the macro?",vbyesno,"Run Macro?")=7 then
Call RunMacro (or something to call the procedure of the macro). The help menu for this function is very useful and will let you know what other buttons you can add.

Dave

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 10:45 AM	#1
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	Is there anyway to use a message box to run macro? MsgBox ("Click to run macro") What about having more than one choice on the message box??

Mar 26th, 2002, 10:58 AM	#2
davers5 Board Regular Join Date: Feb 2002 Posts: 255	See msgbox function in vb help. There are several optional arguments for the function. msgbox("Would you like to run the macro?",vbyesno,"Run Macro?") Will give you a message box with two buttons. If the person clicks yes, then the function will return the integer 7. So you need an if statement that looks like this: If msgbox("Would you like to run the macro?",vbyesno,"Run Macro?")=7 then Call RunMacro (or something to call the procedure of the macro). The help menu for this function is very useful and will let you know what other buttons you can add. Dave