Hyperlink List?

**newbie13** · 05-29-2008, 04:57 AM

Hi All,

Is there any way of having hyperlinks in a drop down box?

Any way at all..?

Please help.

N.

**Andy Pope** · 05-29-2008, 05:38 AM

I don't belive so.

You can always put the links in a dropdown box and then use code to react to a change in the selection of that box.

**newbie13** · 05-29-2008, 05:48 AM

Would I use "sheet code" rather than creating a macro.

My problem is, some people who I am sending this document to will be using a MAC PC. So am trying to avoid using VBA.

Thanks again.

N.

**Andy Pope** · 05-29-2008, 06:15 AM

For a non VBA method you will need two cells.
One holds the list of addresses.

The other uses that as the argument to the HYPERLINK formula.

So for a list of links in F2, using data validation list, this formula would be in F3

=HYPERLINK(F2)

Hyperlink List?

LinkBack

Thread Tools

Rate This Thread

Display

Hyperlink List?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions