[thelist] [semi-OT] Opening Links from Combo Boxes in Excel
Rob Smith
rob.smith at THERMON.com
Fri Apr 1 09:57:35 CST 2005
<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
More information about the thelist
mailing list