Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Setting default values in a drop down list in excel? | Excel Discussion (Misc queries) | |||
Data Validation in Excel - drop down list font size | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) |