ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can links created in a text box be conditional? (https://www.excelbanter.com/excel-programming/381740-can-links-created-text-box-conditional.html)

[email protected]

Can links created in a text box be conditional?
 
I am using text boxes as hyperlinks. Can I make the designation of a
text box link conditional to the value of a cell? For example, if
A1=1, I want the link to go to C1. If A1=2, I want the same text box
link to go to C2 instead of C1. I would like this one text box to link
to as many as 3 possible designations. Is this possible? Thanks.

Michael


[email protected]

Can links created in a text box be conditional?
 

Tom,

Do you have a macro in mind?

Michael



All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com