Stop Macro, Select Cell, Restart Macro

Hi,

Is there anyway to interupt a macro at a certain point to allow the user to select a cell and then restart when a cell is selected?

thanks in advance.

Put in a message box with a simple message such as "Select a cell and press OK"
the macro will then wait until the OK button is pressed.

Hi tenk283, v\
you could use ..

Please Login or Register  to view this content.

Originally Posted by protonLeah

Put in a message box with a simple message such as "Select a cell and press OK"
the macro will then wait until the OK button is pressed.

That doesn't allow the user to select a cell though. Windows just makes that dinging sound.

Thanks Pike. That's what I was looking for! Problem Solved.