replacement for msgbox

[sunilpatel]

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

 

[Joel]

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

 

[Don Guillett]

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.

 

[JLGWhiz]

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.