Hello there,

I have been trying to figure out how to hyperlink the cell value that changes when you select an item from the ComboBox. For example, I created a combobox with a list of products. Then on cell B10, I used the index formula that uses the reference of the combobox to show the product name as it changes from the selection. I was wondering if there is a way where you can have hyperlinks for the products to different parts of the workbook when the value in cell b10 changes. Ex: when it select Shoes, it hyperlinks to sheet2 a4, you select clothes, it hyperlinks to sheet3 a4..etc.

Any help would be great. If there is a way to do this without VBA (since I am not familiar with it) would be great.

Thanks,

Erica