Solved: Selecting Hyperlink using combobox value??

[Simon Lloyd]

Hi all, i have created a userform to look on another sheet that contains a list of Hyperlinks, what i am trying to do is when the specific link is selected in the combobox (CoursBox) then activate that link, ukcourses is the named range (the entire named range is a list of hyperlinks). Any ideas on how to activate the Hyperlink after selecting it in the combobox?

Regards,
Simon

Private Sub CommandButton1_Click()
Dim rng As Range
Dim mycell
Set rng = Sheets("Course Guides").Range("ukcourses")
With CourseBox.Value
For Each mycell In rng
If mycell.Text = CourseBox.Value Then
mycell = Hyperlink.Activate'''Have Problems Here!
End If
Next
End With
Me.Hide
End Sub

[Bob Phillips]

[vba]

Private Sub CommandButton1_Click()
Dim rng As Range
Dim mycell
Set rng = Sheets("Course Guides").Range("ukcourses")
ActiveWorkbook.FollowHyperlink Address:=rng.Cells(CourseBox.ListIndex + 1, 1).Hyperlinks(1).Address
Me.Hide
End Sub
[/vba]

[Simon Lloyd]

We definately aren't worthy 'El Cid'

Worked great

Thanks a lot!

Simon

[Bob Phillips]

We definately aren't worthy 'El Cid'

Worked great

Thanks a lot!

Simon

I thought I was El Xid (I might even adopt that as a moniker).

[Simon Lloyd]

Okay from now on i shall address you as the Great El Xid!

[Bob Phillips]

I wonder if I can get the admin guys to change my id?