View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mrlanier@hotmail.com is offline
external usenet poster
 
Posts: 63
Default 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