On Error Quit Macro - Otherwise keep going

[BobWilson99]

Hi - pretty simple what I am trying to do I have a feeling.....I have an input box in my macro and if the user clicks "Cancel" I want the macro to skip to the End Sub line otherwise execute all the code between the input box line and the End Sub line.

 

[krausr79]

dim x as string
x = inputbox(stuff)
if x="" then goto LastLine: 'or if x="" then exit sub (I don't see an advantage to skipping right to the end of the sub)
...
LastLine:
End Sub

 

[BobWilson99]

thank you Kraus79 - that helped a lot.....cheers