Easy Error Trap Question

[gojohnnygogogogo]

How can I trap and error and do something when that error appears ?

eg. when I get run time error 2220 then
display message "you have an error"

is this possible ?

thanks for any info.

 

[AlexMidd]

Put On Error Goto in your procedure, e.g.

Sub Button1_Click
On Error Goto Err_Button1_Click
....
Code here
....
Exit Sub

Err_Button1_Click:
If Err.Number = 2220 Then
..Error Message here..
Else
..if different error occurs
End If
End Sub Have fun! )

Alex Middleton