pause macro until user selects correct range
Possibly something along the lines of
Dim rng as Range
Dim cnt as Long
do
cnt = cnt + 1
On error resume Next
set rng = Application.InputBox("Select cell with mouse",type:=8)
On error goto 0
do while not rng is nothing or cnt 4
if cnt 4 then exit sub
--
Regards,
Tom Ogilvy
"JCIrish" wrote in message
...
Within an event handler for a worksheet command button I display a msgBox
telling user to select a specific cell. When user clicks OK on the msgbox
how do I pause the macro until he selects the correct cell?
|