Value of VBCancel Same as Variable in InputBox

[TemiU]

Hi All Excel Experts!

I have the following code:

Dim numLs as String

numLs = (InputBox("Enter number of rows to add:", "Add Rows to " & shtName & " " & shtPart))    
If numLs = vbCancel Then Exit Sub

If the user happens to want to add two lines, sub ends.

Any workaround ideas?

Thanks a lot!

 

[Trebor76]

Hi TemiU,

You need to replace vbCancel as it has a value of 2 like so:

If numLs = "" Then Exit Sub

Regards,

Robert

 

[TemiU]

That works - thanks Trebor76!