Hyperlink Picklist

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Calder - 26 May 2008 01:40 GMT

Hi

I run Excel 2000

I have a list of names with each one of them having a hyperlink to an email
address.

These all work fine.

What I would like to do is one of two things.

1st Option

Have a drop down list that lets me choose one of the names from the list and
have it retain its hyperlink properties. I tried using data validation but
the names dont retain their hyperlink properties.

2nd Option

Have a formula that is based on an entry to another cell that returns the
name from the list but retains the hyperlink properties.

Example (in cell G1)

=IF(D1="SUPPLIER 1",HYPERLINK(A1))

(I tried this but it dosnt work so it may be that I have the formula wrong)

Can anyone help?

Thanks

John

Reply to this Message

Gary''s Student - 26 May 2008 12:23 GMT

Hi John:

The technique is to use the HYPERLINK() function. Say the list of email
addresses is from Z1 thru Z100. We put the data validation dropdown in A1.
When an address is picked, it will be "cold" (un-clickable). So in A2 enter:

=HYPERLINK("mailto:" & A1,A1)

A2 will be "clickable"

Signature

Gary''s Student - gsnu200788

> Hi
>
[quoted text clipped - 29 lines]
>
> John

Reply to this Message

John Calder - 26 May 2008 22:08 GMT

Thanks a lots Gary !

> Hi John:
>
[quoted text clipped - 39 lines]
> >
> > John

Reply to this Message

Learning Excel - 30 May 2008 01:39 GMT

I have the same need, Gary( or another excel expert)
but my links are not e-mail addresses,
they are websites.
Q : it is possible to click in the dropdown list , get the website address
and follow that link just like this example for e-mail addresses ?
If yes which formula I can use and how ?
Same example, z1 to z100 and drop down in A1.
THANKS.

Signature

Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

> Thanks a lots Gary !
>
[quoted text clipped - 41 lines]
> > >
> > > John

Reply to this Message

Gary''s Student - 31 May 2008 01:31 GMT

Very similar to email. with a "cold" hyperlink in A1 use:

=HYPERLINK(A1,A1)

Signature

Gary''s Student - gsnu200789

> I have the same need, Gary( or another excel expert)
> but my links are not e-mail addresses,
[quoted text clipped - 50 lines]
> > > >
> > > > John

Reply to this Message