Forms Combo Box with Hyperlinks

I've searched and searched for the answer to this question and I see a lot of cross postings without the answer.

I have 2 sheets in a workbook. 1 is “Report” the other is “CHG”. I’ve created the Combo box from the form menu and the box is on the “Report” sheet. On the “CHG” sheet, I have the list I want to use.

I first tried to create the hyperlinks in the cells of the list and then link the Combo box to that list… didn’t work.

From what I’ve found in this forum is that I need an action on the Combo box to make the links work when selected in the box.

This is where I need the action but I don’t know what code to enter here. I’ve done this with buttons so I don’t know why I can’t figure this one out… pretty sad on my part I feel.

Please Login or Register  to view this content.

I prefer the combobox in the Control Toolbox toolbar.

e.g.

Please Login or Register  to view this content.

We are close.. how do I get the name in the range to appear and not the hyperlink in the VB code?

This is not fool-proof but might work for you.

Please Login or Register  to view this content.

Thanks for you help but this doesn't work. I've tried a few things and it's close but not correct. I can click the drop down and click a blank space and it works, but not the word in the drop down.

Post your code or your xls if you want us to troubleshoot it.

If you uncomment the lines where I added the hyperlinks, it would work.

Hyperlinks come in 3 forms so I can't be sure where it would go wrong in yours.