Excel 2003 Lists and Hyper links
 

How can I get Excel to display a dropdown list of Hyperlinks? I tried the
Validate command but did not get very far. Thank you in advance.

Excel 2003 Lists and Hyper links
 

You probably have already found that referencing a list of hyperlinks in a
data validation drop-down produces only "cold" hyperlinks (not clickable).
However, say we put the dropdown in B1; in A1 enter:
=HYPERLINK(B1)

This will produce a nice, "hot", link in A1
--
Gary''s Student - gsnu200751


"PETER J" wrote:

How can I get Excel to display a dropdown list of Hyperlinks? I tried the
Validate command but did not get very far. Thank you in advance.