Trapping errors

[ssemtaf]

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]

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

 

[Chip Pearson]

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)