Thread: error trapping
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] john.9.williams@bt.com is offline
external usenet poster
 
Posts: 104
Default error trapping

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