Thread: error trapping
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
anonymousA anonymousA is offline
external usenet poster
  
Posts: 32
Default error trapping
a écrit :
Hi all,

I have just used error trapping for the first time and i am having some
problems with it. here it is

sub test()

on error goto errortrap
Unload Me


Sheets("codes").Select

UserForm1.Show

errortrap:

unload me
userform7.show


if there an error i wish to display another userform, however at the
moment if theres no error the program will run but still display the
userform7 at the end of the program instead of ignoring it, any help
greatly accepted

regards

johny

Hi,

before errortrap:, insert a line with the instruction Exit Sub and it'll
fix it.

So long
Reply With QuoteReply With Quote