Hyperlinks to change drop down selection

[mweigold]

Hello,

Currently I have a Windows 7 computer with Microsoft Excel-Office professional plus 2016 installed. I have a form control (combo box-drop down) set up. I would like to create a hyperlink so that when you click on it, it changes the drop down selection on the control box, making them interactive with each other.

Is it even possible to change a drop down via another way? Can you reference keys? Most of the forums have drop downs changing cell data. I want cell data to change a drop down.

What I am wondering is if this can even be done with my version of excel or would I need to get a different version. Please advise. Thanks.

 

[mrmmickle1]

Put this in the worksheet module and change the ComboBox Name accordingly:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    'When a hyperlink is clicked select the first item in the list
    Me.Shapes("Drop Down 1").ControlFormat.ListIndex = 1
End Sub

 

[mweigold]

Thank you for responding. Let say we have a list of different fruits, apples, oranges etc. On a different sheet if we click on apples (make this a hyperlink) we want the drop down (in another sheet) to change to apples. Should our hyperlink just be sent to the sheet that has the drop down? This code doesn't specify how to set where the hyperlink should be going. When I type in your code it just pulls up a macro box. Please let me know.