Hello!
I'm new to this forum. I have been working in Excel for about 10 years now but have advanced to some pretty interesting levels in the past 6 months.
I'm stuck on this new problem. My boss wants a drop down menu in Excel that will return a hyperlink WITHIN the spreadsheet. She doesn't want external hyperlinks.
I am a novice VB user and looking to find a way to do this in Excel. She wants Excel not Access.
Thank you in advance for your help.
Bonnie
You dont need VBA for this. If your DD is in A2, try this...
=HYPERLINK("#"&"'"&A2&"'!A1",A2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you Ford for your prompt response!
I'm a bit of a newbie at these kinds of forums and your shorthand flew right over my head.
Where do I try the =HYPERLINK("#"&"'"&A2&"'!A1",A2) ? In the cell next to the drop down box? Does is format the dropdown box to return hyperlinks instead of text? I will have a column of these dropdown boxes because it is a tracking spread sheet.
My apologies.
1. You would put the that formula where you want the hyperlink to appear.
2. It assumes that the dropdown (DD) is in A2. you would adjust this as needed.
3. The A1 is the cell that the hyperlink will take you to. This can also be adjusted as needed.
4. the last A2 reference takes the contents of A2 (the dropdown) and uses that for the Hyperlink name
Shout if anything is still unclear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks