Drop down list includes hyperlink
 

I have properly built a drop down list that features two choices. These
referenced choices have hyperlinks however the hyperlinks don't work when
selecting from the drop down???

Is there a way to make the drop downs choices be hyperlinked?

if not

Is there a way to make sure the user's entry has the hyperlink active? (In
otherwords hyper link the cell or series of cells rather than the entry?)

Thanks for any help...

Mark

I don't think you can.

And the answer is gonna depend on how you built those dropdowns.

Did you use Data|Validation
did you use a dropdown from the Forms toolbar
did you use a combobox from the control toolbox toolbar

And what version of excel are you using?

Mark Renfrow wrote:

I have properly built a drop down list that features two choices. These
referenced choices have hyperlinks however the hyperlinks don't work when
selecting from the drop down???

Is there a way to make the drop downs choices be hyperlinked?

if not

Is there a way to make sure the user's entry has the hyperlink active? (In
otherwords hyper link the cell or series of cells rather than the entry?)

Thanks for any help...

Mark

--

Dave Peterson