Ideally, you would execute vba code to accomplish what you're asking, but....
If that doesn't appeal to you, you might want to try this approach:
Set up a Data Validation cell that references a list of URLs.
Example:
With
D1:
www.google.com
D2:
www.contextures.com
Select B2
<data<validation
Allow: List
Source: $D$1:$D$2
Click the [OK] button
C2: =HYPERLINK("http://"&B2,"Go To That Link")
The user would select the website from the dropdown list in B2
then click "Go To That Link" in C3 to open that web page
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Keith" wrote:
I want to make a drop down list where the list is a range of cells containing
hypelinks so that your choice fron the dropdown list will execute the
corresponding hyperlink. Is this possilble?
--
Keith