Pause Macro 2
have another pause macro problem.
I have created a macro
Dim myStr As String
myStr = InputBox(Prompt:="Please enter your name")
Range("a3").Select
ActiveCell.FormulaR1C1 = myStr
MsgBox " You entered:" &myStr
"other code that does more
The input box has 2 options OK and Cancel.
If I click on cancel it still continues with the "other code that does more"
instead of quiting the macro.
Would appreciate any help.
Thanks
|