Processing a Message Box w/in a Macro

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I could use help with the following;

I have a macro and when I run it, it displays a message box offering
three choices, "OK, Cancel and Help". When I choose "OK", the macro
continues to run to a successful conclusion. I want to process this
message box within the micro with the choice "OK". To accomplish
this I use the following code:

Application.DisplayAlerts = OK

When I run the macro initially, the message box still appears even
with this code. I click "OK" and the macro continues sucessfully. If
I run it a second time or subsequent times with the same or different
data, I do not see the message and the macro runs successfully. Only
the initial time the message is displayed.

How do I get the macro to run the initial time without having to
manually process the message box?

Thanks in advance for the help.

Randy
 
Back
Top