VBA error handler

[sirte]

I am trying to add a simple error handler to a UserForm
Basically something like this



If Cell xxx ="#VALUE!".then
UserFormXXXX.show

Else

do nothing

End else

Exit sub

 

[RoryA]

If you want to show the form when a cell contains an error, you can use:

If Iserror(cells(x, y)) Then userformxxxx.show