Ye Olde Combo Box Hyperlink Question

[IGWright]

Hi,


I've searched high and low for answer, and I think I'm getting close.

I've got a Combo Box that I want to be able to attribute Hyperlinks to.

I would like to be able to select one of the options from the Combo Box and have the Hyperlink fire automatically.

The conditions are:

Workbook Name: Floor Plan
Combo Box Worksheet Name: Switched 2
Input range: 'Combo Box'!$A$1:$A$4
Cell link: $CU$80

Drop down lines with corresponding Hyperlink Named ranges:
R FRONT R_FRONT_Hardwired
L REAR Audio_1_AZ80
120V-60HZ 4A ER_16_PC_100A_Outlet_6
R REAR Audio_1_AZ80

Here's the Code I've got:

Private Sub ComboBox_Change()


If ComboBox.Value = "R FRONT" Then
Sheets("Combo Box").Select
Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If

If ComboBox.Value = "L REAR" Then
Sheets("Combo Box").Select
Range("A2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If

If ComboBox.Value = "120V-60HZ 4A" Then
Sheets("Combo Box").Select
Range("A3").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If

If ComboBox.Value = "R REAR" Then
Sheets("Combo Box").Select
Range("A4").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If

End Sub

It is not working and I'm sure there are a number of reasons why. I appreciate that this is a lot to ask, but I have been at this for days and I've reached a point where I can't seem to move it any further on my own.


Any help would be greatly appreciated,


Ian