Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping errors
Hi,
I have a sheet with some controls. If a debug situation occurs I don't want the user to flung into vba land. A calming MsgBox with some advice to do something or other would be less traumatic. Does anyone have some code for this please. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping errors
Lots of times, you can just turn off error checking, do the thing that may cause
an error, then check for an error, and turn error checking back on. On error resume next 'some code that could cause an error if err.number < 0 then err.clear msgbox "Don't Panic" 'more code??? end if on error goto 0 ssemtaf wrote: Hi, I have a sheet with some controls. If a debug situation occurs I don't want the user to flung into vba land. A calming MsgBox with some advice to do something or other would be less traumatic. Does anyone have some code for this please. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping errors
I have some notes about how to implement error handling at
http://www.cpearson.com/Excel/ErrorHandling.htm Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Mon, 27 Oct 2008 09:51:31 -0700 (PDT), ssemtaf wrote: Hi, I have a sheet with some controls. If a debug situation occurs I don't want the user to flung into vba land. A calming MsgBox with some advice to do something or other would be less traumatic. Does anyone have some code for this please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trapping errors in a VLOOKUP function | Excel Worksheet Functions | |||
Trapping errors with Conditional Formatting | Excel Discussion (Misc queries) | |||
GetOpenFilename - Trapping Errors | Excel Programming | |||
Trapping Workbook OPEN errors | Excel Programming | |||
annoying bell when trapping errors | Excel Programming |