MsgBox -change vpOk to VpOkStop
 

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

MsgBox -change vpOk to VpOkStop
 

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

--
Regards,
Tom Ogilvy


"rleonard" wrote in message
...
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
macro

Dim var As Variant
var = 37
MsgBox var & " is Row Number"

thanks
Bob Leonard