Can I use an error message to launch a macro?

[MGumbrell]

I have a range of cells with a dropdown list if the user does not pick from the list and types an entry the following expected error notice is given:-

"The value you entered is not valid"
"A user has restricted values that can be entered into this cell"

On this error, instead of receiving it could it be used to launch a macro, in particular a UserForm and to not see the error notice.

Thanks, Matt

 

[HaHoBe]

Hi, Matt,

as this would long for VBA to handle I would prefer to present a Userform instead of Data/Validation and handle everything from there in VBA...

Ciao,
Holger

 

[MGumbrell]

OK Holger Thanks.

Regards, Matt