how to hyperlink in a data valitation list?

  • Thread starter Thread starter tomy
  • Start date Start date
T

tomy

Hello, I want to hyperlink in a validation list I have tried something that I
seen on youtube in "
" 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.
 
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
 
Back
Top