I have a data validation list. One of the names on the list is "dog".
What I want to do is after I select "dog" from the list, I want it to
link to a customer form. It is like combine two different functions
into one. It is just like a cell which has data validation and that
same cell also has a hyperlink. It is like clicking cell A1 and select
"dog" from list, and this very same cell A1 opens up another link
after the "dog" is selected. I know how to do both separately on
different cells and without any Macro. But I don't know if a Macro can
be done on this! Can anybody help? Thanks.