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.
On Error Resume Next
sMyPath = InputBox("Enter Folder path. Example: C:\MEASURE-6000\OUTPUT\", , "C:\MEASURE-6000\OUTPUT")
If Err.Number = 13 Then Exit Sub
On Error GoTo 0
sMyFileType = InputBox("Enter File type. Example: txt = Text file, csv = Excel CSV file, xls = Excel XLS file, xlsx = Excel XLSX file, etc.", , "OUT")
If Err.Number = 13 Then Exit Sub
On Error GoTo 0
Any hints, tips or examples are welcome.
Bookmarks