MsgBox -change vpOk to VpOkStop

R

rleonard

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
 
T

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
 
Top