macro pause until mouse click

[Pablo]

Hello:

Trying to figure out a way to make a macro pause, until the mouse (or
any other simple input) is clicked on the active screen, window, etc.
before proceeding.

Thanks!

 

[jeff]

You could just put up a message box..

msgbox("Continue..")

 

[David McRitchie]

Of course nothing else will be happening in Excel in the meantime.

Same applies to InputBox which gives more flexibility, if you want
to change what is going to happen..
InputBox and MsgBox
http://www.mvps.org/dmcritchie/excel/inputbox.htm

 

[Rollin_Again]

The only problem with using a Messagebox or input box is that you
workbook will be in a frozen state until you click on one of th
buttons. The only way you will be able to make changes or navigate t
other parts of the worksheet is to go into break mode by pressing CTR
+ BREAK. Once the VB editor comes up you minimize it and move aroun
freely to check data or to view other worksheets. When you are read
to resume the code, you would have to bring up the VB editor and clic
in it to set focus and then press F5.

Rolli