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

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

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

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