MsgBox -change vpOk to VpOkStop

[Guest]

Need to change so that If 37 is incorrect Ican stop or cancel running of Macro

the number "37" is changed by using Edit Find & Replace while editing macr

Dim var As Varian
var = 3
MsgBox var & " is Row Number

thank
Bob Leonar

 

[Tom Ogilvy]

Dim var As Variant
Dim ans as Long
var = 37
ans = MsgBox (var & " is Row Number, is this correct", vbYesNo)
if ans = vbNo then _
exit sub