Gringo287,
Ok, I think I see what you are trying to do... A few recommendations:
First, you are using form controls not activeX controls. The activeX controls in my humble opinion are easier to use and more accessable (you can see properties and call them easier etc). I am not sure what version of excel you are using, but if it is 2007 and beyond, you are much better off using the activeX controls.
Second, you need to fill your combo box with choices. This can be done on workbook open or on sheet activation or by clicking an update button. I used workbook open to keep it the same design as what you had. Note: I am filling the data with column 1 which is op1 etc... this way you can have the name of the video not the url showing up in the combobox. I just search for it later and offset to the url. Anyway, the code looks like this:
Private Sub Workbook_Open()
Dim l As Long
Dim s As String
sheet1.combobox2.clear
For l = 4 To Sheet1.Range("A65536").End(xlUp).Row
s = Sheet1.Cells(l, 1)
Sheet1.ComboBox2.AddItem (s)
Next l
End Sub
Third: Now that you have the combobox filled, you need to add code to the command button to navigate to the website. I chose to use activeworkbook.followhyperlink because you dont need any references etc and it is easy to use. Again, note that I am offsetting the found selection so you can use a name and send the url. You could change this to suit your needs. That looks like this:
Private Sub Workbook_Open()
Dim l As Long
Dim s As String
For l = 4 To Sheet1.Range("B65536").End(xlUp).Row
s = Sheet1.Cells(l, 2)
Sheet1.ComboBox2.AddItem (s)
Next l
End Sub
To make everything a little more understandable, I have attached a working workbook that I think does what you want...
Good luck to you.