Processing a Message Box w/in a Macro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top