Message Boxes in Macros

  • Thread starter Thread starter GLS
  • Start date Start date
G

GLS

Can someone tell me how I can incorporate a yes/no
response, to confirm an action (such as appending to a
table) in to a macro? I know you can stop them using
the 'Tools' 'Options' function but I'd rather build them
into the macro.

many thanks
GLS
 
Use MsgBox() in the Condition column of your macro.

If you do not see a Condition column, use the View menu.

Example of what to use in the Condition column:
MsgBox("Proceed?", 4) = 7
and then in the Action column:
StopMacro
 
Thanks Allen. That's great.

GLS
-----Original Message-----
Use MsgBox() in the Condition column of your macro.

If you do not see a Condition column, use the View menu.

Example of what to use in the Condition column:
MsgBox("Proceed?", 4) = 7
and then in the Action column:
StopMacro

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top