| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Processing a Message Box w/in a Macro
Not enough info. Please post your code...
Randy wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Batch Processing Macro | Excel Programming | |||
| Processing...Please Wait Message Box | Excel Discussion (Misc queries) | |||
| Macro for Row Processing | Excel Programming | |||
| Display message: Processing.... | Excel Programming | |||
| processing message | Excel Programming | |||
Threaded Mode
