A listbox has a click event and in that event you can do whatever you want
with the item(s) selected in the listbox.

The listbox doesn't support a hyperlink per se, but using the click event,
as I said, you should be able to do what you describe.

And yes, I have done similar.

--
Regards,
Tom Ogilvy


"RK" wrote in message
...
I have 35+ spreadsheets, that based on the year and the
Quarter, I would be able to select the Hyper-link to the
spreadsheet and send data to that particular spreadsheet
to print.

RK



-----Original Message-----
What would be the purpose of a listbox with hyperlinks?

--

Vasant

"RK" wrote in
message
...
Can anyone help me? ?? MVP ???

For two months I have posted and I still don't have an
answer.

How can I do a listBox with Hyper-links? I can do it
with
other lists both through the wizard or VB, but have
been
unsuccessful with hyper-links, all that is displayed is
the friendly name or nothing at all! Is there an
example
out there that I can look at? I haven't found anything
on
the Web or Microsoft.

Before posting, please try it for yourself. I have had
comments that "try this, (example)" this should work,
but
it hasn't. The examples do work on normal lists.

Thank you for your help.

RK



.