Drop-Down List of Hyperlinks

Hello, I have created 10 different hyperlinks in excel and each hyperlink references a word document. I am attempting to create a dropdown list of these hyperlinks so that when I choose the item from the dropdown, I can double click on it and it will go directly to the word document.

When I create the drop down list (using data validation) the drop down list appears but all the items are no longer hyperlinked to the word document originally referenced.

Any help would be greatly appreciated

Need to add one line of code at the beginning of JaSal's macro. That line is to clear the previous entry in cell "HyperLink_Selected".

His code will now look like:

Sub Whatever you name it()

Call Range("HyperLink_Selected").ClearContents
HyperLink_Index = Range("HyperLink_Selected")
If Range("HyperLinks_Table").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Name <> "" Then
Range("HyperLinks_Table").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

End If

That's not all!

Next

In Format Control

enter the Input Range
enter the Cell Link
enter number of Drop Down lines

Now .. you're good to go

Best

Dick

Well it works, although as already mentioned, visualisation would have been helpful.
Anyway, thanks for the workaround.

The data validation dropdown list is positioned in cell A1 and a

=HYPERLINK(A1;"Goto Link")

in cell A2. The crucial point is to fill the list with the hyperlink_address part of the HYPERLINK-Function.
So the source of the list: in my case an entry looked like this:

[Test.xlsm]Sheet1!A100

This part just replaces the A1 in

=HYPERLINK(A1;"Goto Link")

to form

=Hyperlink([Test.xlsm]Sheet1!A100;"Goto Link")

This only works using the function. If you insert a hyperlink over the menu it won´t work.

Hope that helps.

Good Luck

including screenshots would be more helpful :)

The problem can be easily solved with a bit of VBA and using a drop down box. To set up:

1. Create a named range (n rows, 1 column) called "HyperLinks_Table" than contains the list of hyperlinks.

2. Create a named range (1 cell only) called "HyperLink_Selected". Leave this cell blank.

3. Add a ComboBox form control to your spreadsheet. Format the control (right click) to have the following values:
Input Range: HyperLinks_Table
Cell Link: HyperLink_Selected

4. Right click the ComboBox control and select the "Assign Macro" option, click new to create a new macro. Add the following lines to the macro:

HyperLink_Index = Range("HyperLink_Selected")
If Range("HyperLinks_Table").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Name <> "" Then
Range("HyperLinks_Table").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If

Now when you change the value in the ComboBox the hyperlink will be opened.

Mine did not work either !! Please explain..........

I tried this but it didn't work. I really need to be able to make a drop down list that will link to elsewhere in the same worksheet. I have 2 drop down lists and both are needed for my purposes. I concatenate the results to another cell so the full text is in one cell, Then I want to have a "go" link that will take the user to the place in the document they just selected with the 2 drop downs. Any help would be appreciated.

I have an Excel 2010 file that has a drop down menu with options in the drop down, to sort a-z and another line to sort z-a. It also has a search field. It also has a list that you can put a check-mark next to, so you can print different criteria from that list. I don't know if I am explaining myself very well. I tried to copy and paste a view of it in this block, but the block will not allow me to do that.