Simon Lloyd
09-15-2006, 01:38 AM
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
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