Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to hyperlink in a data valitation list?
Hello, I want to hyperlink in a validation list I have tried something that I
seen on youtube in "http://www.youtube.com/watch?v=p_77cZ1Vyl4" I did the exact thing this person did and it didn't work, and when this person did it on YOUTUBE it did work. There one diference he has Office 2007 and I Have Office 2003 student edition that might be the resson that it dosen't work. What I want to do is find a name in a list by using a Drop Down List on the same page. Thank you for you answers in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to hyperlink in a data valitation list?
You need to use an extra cell when picking up hyperlinks with data validation:
Say E1 thru E3 contain: http://www.cnn.com http://www.abc.com http://www.bn.com And we use a Data Validation list in cell A1 to pick one of these three options. You will discover that, even though we pick a hyperlink, A1 will be AS cold as ice. Unclick-able However, if in B1 we enter: =HYPERLINK(A1) we will get a "click-able" version of the link in A1 -- Gary''s Student - gsnu200818 "tomy" wrote: Hello, I want to hyperlink in a validation list I have tried something that I seen on youtube in "http://www.youtube.com/watch?v=p_77cZ1Vyl4" I did the exact thing this person did and it didn't work, and when this person did it on YOUTUBE it did work. There one diference he has Office 2007 and I Have Office 2003 student edition that might be the resson that it dosen't work. What I want to do is find a name in a list by using a Drop Down List on the same page. Thank you for you answers in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink from dropdown list | Excel Discussion (Misc queries) | |||
list and hyperlink | Excel Discussion (Misc queries) | |||
Non VB (simple VB) Hyperlink Data Validation List | Excel Discussion (Misc queries) | |||
hyperlink in drop-down list | Excel Worksheet Functions | |||
Adding valitation list | Excel Discussion (Misc queries) |