Text and hyperlink in the same cell
 

Hello -

In a dropdown box the user selects a state. Using data validation and the
indirect function, a list of approved hotels based on the state appears in a
second dropdown.

My list looks like - Holiday Inn - www.holidayinn.com (the hyperlink is
active)

but, the hyperlink is not active in the dropdown. I'd like it to be active
so the user can click and make the hotel reservation.

Thanks for any help.

Marc

Text and hyperlink in the same cell
 

What appears to be a reasonable solution to your problem may be at

'Excel: Data Validation lists and hyperlinks, target validation, target
value' (http://tinyurl.com/kn5xjm)

let us know if it worked for you... :Bgr


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117339