ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   to open up a link (https://www.excelbanter.com/excel-programming/310377-open-up-link.html)

JC[_9_]

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