C
cincode5
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...
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...