Application.Wait(Now + #0:00:10#)
Stop
If IsEmpty(Cells(1, 1)) Then
Cells(1, 1).value = InputBox("A1 is not populated. Please populate it.")
Else
'do nothing
End If
He is correct. As long as the only value you would like to change is "A1" =)So at the point of where you want to break the code, put that code in there. This will prompt for user input. It's the same as passing control to the user.
thanks - there is a definite place in the code where I want to check if say cell A1 is still empty, but to get a value into A1 I need to "stop" the macro - can a macro be made to pass or offer control to the keyboard ?
Do Until Range("A1").Value <> ""
DoEvents
Loop