Embedding a Hyperlink
 

I have a spreadsheet that contains a pull down menu which populates various
cells with information contained on a seperate worksheet. For example, this
site, when selected displays my user ID, my password, site comments, and the
URL. I used VLOOKUP to accomplish this, but what I haven't figured out is
how to actually make the cell containing the URL a hyperlink. I know about
Inserting a Hyperlink, but I want that to happen automatically whenever I use
the pull down. Is there a VBA routine that can accomplish this?

On another note, I wanted to express my sincere condolences to those of you
who knew and/or worked with Frank Kabel. I just read the post by Norman
Harker this morning, and although I didnt personally know Frank, I knew of
him. He helped me in the past with a couple of posts, and you know what:
that made it personal. His insights, his knowledge, and all of his
contributions to this community will be greatly missed.

God speed to you Frank...
--
Regards...

Try this.....

=HYPERLINK(VLOOKUP(cellref,table,col,0))


Gord Dibben Excel MVP


On Mon, 24 Jan 2005 12:01:04 -0800, "cincode5"
wrote:

I have a spreadsheet that contains a pull down menu which populates various
cells with information contained on a seperate worksheet. For example, this
site, when selected displays my user ID, my password, site comments, and the
URL. I used VLOOKUP to accomplish this, but what I haven't figured out is
how to actually make the cell containing the URL a hyperlink. I know about
Inserting a Hyperlink, but I want that to happen automatically whenever I use
the pull down. Is there a VBA routine that can accomplish this?

On another note, I wanted to express my sincere condolences to those of you
who knew and/or worked with Frank Kabel. I just read the post by Norman
Harker this morning, and although I didnt personally know Frank, I knew of
him. He helped me in the past with a couple of posts, and you know what:
that made it personal. His insights, his knowledge, and all of his
contributions to this community will be greatly missed.

God speed to you Frank...

Thanks Gord,

That was (embarrisingly) easy. Sometimes I think I try to hard to find
complex solutions for simple problems.

"Gord Dibben" wrote:

Try this.....

=HYPERLINK(VLOOKUP(cellref,table,col,0))


Gord Dibben Excel MVP


On Mon, 24 Jan 2005 12:01:04 -0800, "cincode5"
wrote:

I have a spreadsheet that contains a pull down menu which populates various
cells with information contained on a seperate worksheet. For example, this
site, when selected displays my user ID, my password, site comments, and the
URL. I used VLOOKUP to accomplish this, but what I haven't figured out is
how to actually make the cell containing the URL a hyperlink. I know about
Inserting a Hyperlink, but I want that to happen automatically whenever I use
the pull down. Is there a VBA routine that can accomplish this?

On another note, I wanted to express my sincere condolences to those of you
who knew and/or worked with Frank Kabel. I just read the post by Norman
Harker this morning, and although I didnt personally know Frank, I knew of
him. He helped me in the past with a couple of posts, and you know what:
that made it personal. His insights, his knowledge, and all of his
contributions to this community will be greatly missed.

God speed to you Frank...