Printable View
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?
[vba]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
[/vba]
Something like that
It is err.Number and err.Description, not err.Num and err.Name.
Yeah sorry about that. Had just woke up.
it works. thanks.