Data Validation/Drop Menu with Hyperlinks?

[LilT782]

Hello Everyone... I need some serious help as I need to put together a report for work.


What I want to do is this:


Create a drop menu. The options within the drop menu to be links (either to another Excel worksheet within the same workbook, or a WORD document).


I know how to create a drop menu, that is simple, but am not sure how to do the hyperlink aspect.


It seems when I actually insert>hyperlink onto the actual text of the drop menu (on the other sheet where i created the drop menu data), the hyperlink is not active in the actual drop menu itself.

Can somebody please help me?

[mikerickson]

Your drop down_Click routine can
1)Find which item was selected
2)Calculate the cell from which the item came
3)Activate the hyperlink in that cell.

This does that with a Shapes Combo box (from the forms menu).
Its list is 1 based. ActiveX dropdowns (from the toolbox) are 0 based.

Please Login or Register  to view this content.

[hkelley10]

Hello,

I am new to using the Developer tab, but I am having the same issue. I'm not sure where/how to input the code above to activate the hyperlink I am choosing via the dropdown list. Can someone help? Thank you!