Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Handling Problem
Greetings,
How do I set up an error handling routine that does not though me into an endless loop? I have a UserForm (UF1) with a TextBox (TB1), in which I need a date entered into. When I exit TB1, I have the format changed to mmm dd, yyyy. This works fine. the problem arises when the person entering the data mistypes something in TB1 and it is NOT a legitimate date. On exiting TB1, they get an error message telling them that they have a type mismatch asking about debug. I have tried to use on error to generate a msgbox and then unload the userform and then reload it, but that just freezes my machine and I have to Control, Alt, Delete out of Excel (we wont discuss lost data at this time). So, the question is how do I set up an error handling routine? Is there any info out there on the logic and design of error handling routines? Any help would be appreciated. TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error handling problem | Excel Discussion (Misc queries) | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Error Handling | Excel Programming | |||
Excel VBA - Error handling problem | Excel Programming | |||
Error handling | Excel Programming |