![]() |
to open up a link
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. |
All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com