View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default excel drop down list of hyperlinks

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