Solved: Error Handling Help

[doctortt]

Hi,

My Excel program will throw out some errors like "run-time error 380:" And I would like Excel to show a msgbox to tell the user to change the values of the variables instead of throwing this run-time error message. Can someone please show me how to write such codes?

[BrianMH]

sub test

on error goto errorhandler

'your code

exit sub

errorhandler:
if err.num = 380 then
msgbox("your message")
else
msgbox(err.name & ", " & err.num)
end if
exit sub

Something like that

[Bob Phillips]

It is err.Number and err.Description, not err.Num and err.Name.

[BrianMH]

Yeah sorry about that. Had just woke up.

[doctortt]

it works. thanks.