Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacement for msgbox
mid way through code instead of using msgbox i wish to present a message to
the user in cell "B3" (appropriately formated), at this point i want to halt processing until an object/shape on screen ("continue") is clicked. i thought about assigning the object to a macro, but how do you stop the code and restat it fro where it stopped. Sunil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacement for msgbox
You can't restart a macro. You can split the macro into pieces and run on
pice before the object is clicked. Then run the second macro using an event when the object is clicked "sunilpatel" wrote: mid way through code instead of using msgbox i wish to present a message to the user in cell "B3" (appropriately formated), at this point i want to halt processing until an object/shape on screen ("continue") is clicked. i thought about assigning the object to a macro, but how do you stop the code and restat it fro where it stopped. Sunil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacement for msgbox
What happens if they don't see the message in cell b3? And, what happens
when they click the continue shape when it is not needed. Seems to me that the message box IS appropriate. -- Don Guillett Microsoft MVP Excel SalesAid Software "sunilpatel" wrote in message ... mid way through code instead of using msgbox i wish to present a message to the user in cell "B3" (appropriately formated), at this point i want to halt processing until an object/shape on screen ("continue") is clicked. i thought about assigning the object to a macro, but how do you stop the code and restat it fro where it stopped. Sunil |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacement for msgbox
Or you can learn to use InputBox method to allow the user to enter and alter data while the macro is paused. It is all in the design of the program. If the programmer anticipates that a user will need to manually edit the worksheet while the macro is running, it can be handled by designing the type of controls into the system that allows these edits to occur without having to "stop" the macro. "Joel" wrote in message ... You can't restart a macro. You can split the macro into pieces and run on pice before the object is clicked. Then run the second macro using an event when the object is clicked "sunilpatel" wrote: mid way through code instead of using msgbox i wish to present a message to the user in cell "B3" (appropriately formated), at this point i want to halt processing until an object/shape on screen ("continue") is clicked. i thought about assigning the object to a macro, but how do you stop the code and restat it fro where it stopped. Sunil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox Replacement w/ an UserForm | Excel Programming | |||
MsgBox Replacement w/ an UserForm | Excel Programming | |||
MsgBox Replacement w/ an UserForm | Excel Programming | |||
MsgBox Replacement w/ an UserForm | Excel Programming | |||
MsgBox Replacement w/ an UserForm | Excel Programming |