Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error trapping
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
error trapping
Hi, think you want to exit the sub before userform7.show is executed.
Then if there is an error, I believe that it will go to your errortrap:, which will then show userform7. sub test() on error goto errortrap Unload Me Sheets("codes").Select UserForm1.Show exit sub errortrap: unload me userform7.show exit sub Good luck--Lonnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Trapping from WSH | Excel Discussion (Misc queries) | |||
Error trapping | Excel Programming | |||
trapping error | Excel Programming | |||
Error Trapping | Excel Programming | |||
error trapping | Excel Programming |