• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Hyperlink via a Text Box

C

C-Dawg

New Member
I have successfully set up a dynamic hyperlink in a cell using
=HYPERLINK("#'"&$C$9&"'!$C$11","Edit Roster"), where the contents of C9 is the name of the worksheet I want to link to. However, I now want to use a text box instead, so I can place the link in a header. I have tried the same command in the text box hyperlink, but it returns "Reference is not valid".

I was thinking the hyperlinks would work the same whether it was in a cell or on an object.

Thanks in advance for any help.
 
Text boxes can only link to a cell directly
So the text box can have =$A$1
And A1 can have the link address
 
Hi ,

A textbox can be assigned a hyperlink , but it cannot be through a formula ; if you wish to make it dynamic , probably VBA can help.

Assigning a cell address to a textbox , and having a hyperlink in the referenced cell will not help , since you cannot click in the textbox ; to click in the textbox , you need to either assign a hyperlink or a macro.

Assigning a macro which can then dynamically change the hyperlink address and navigate to that address seems to be possible.

Narayan
 
Thanks for the suggestions. I was trying to avoid writing a macro as one of my goals is to have the spreadsheet functional on an iPad eventually.
 
You must log in or register to reply here.
Back
Top