[thelist] [semi-OT] Opening Links from Combo Boxes in Excel

[Rob Smith]

<snip>
You have to make sure that it is in fact a hyperlink. Click
Insert->Hyperlink and follow the directions. If you need to edit you can
right click the cell and makes your edits
</snip>

No dice. You can't have a combobox selected and choose Insert>Hyperlink.
That option is grayed out. I have gotten the following to work:

Sub DropDown1_Change()
    Dim RetVal
    RetVal = Shell("C:\Program Files\Microsoft Office\Office\WINWORD.EXE",
1)
    AppActivate RetVal
End Sub

but not this:

Sub DropDown1_Change()
    Dim RetVal
    RetVal = Shell("http://www.thermon.com", 1)
    AppActivate RetVal
End Sub

Says file doesn't exist. Then my next question is that I can point this to
IExplore.exe or whatever. Does IE take arguments? Can Shell in the macro
handle passing arguments? The manual doesn't suggest that I can do that.

Rob