On Error Resume Next

[Rick_Stanich]

Why doesn't this code exit on the first "Cancel" selection from the first inputbox?
When I select Cancel from the first inputbox it goes to the next inputbox and I have to select Cancel again, then it exits the sub.

Please Login or Register  to view this content.

Any hints, tips or examples are welcome.

[sweep]

Hi,

If you press cancel, the inputbox will return an empty string (""), not generate an error.

Please Login or Register  to view this content.

[DonkeyOte]

If sMyPath is declared as a String hitting Cancel won't generate an Error merely an empty String variable so the Err.Number will be 0.

Also, beware how you're using your handlers... once you reset via the GoTo 0 it follows that were the 2nd InputBox to generate an Error (again not possible if using String variable) then the Resume Next is no longer active and would thus generate Debug.

For more info. on handling see: http://www.cpearson.com/excel/ErrorHandling.htm

[romperstomper]

Alternatively, if you use Application.Inputbox instead, it will return False when you press Cancel.

[Rick_Stanich]

Thanks to all, skooled again.