Hyperlink in multicolumn listbox

I have created multicilumn listbox which display data from sheet1 range
a1:d4.But in column c I have hyperlinks og when thix column is shown in
listbox is shown as text not as hyperlink. How can I display hyperlink i
multicolumn listbox?

Hello Alen32,

To "Hide" the hyperlink URL you must change the hyperlink's "Range" property. The example below assumes there is a hyperlink in cell B10 that is a URL to MSN. We can hide the URL and have B10 show "Go to MSN". If the user clicks on B10, Excel will try to connect to "http://www.msn.com/".

Example of "Hiding" the URL:

B10 = "http://www.msn.com/"
Range("B10").Hyperlinks("http://www.msn.com/").Range = " Go to MSN"

Hope this helps you out,
Leith Ross

You can't.

However, you can use the click event to make it perform like a hyperlink.

--
Regards,
Tom Ogilvy

"Alen32" <bingo190@yahoo.com> wrote in message
news:0e2dbceb05178ab9bddeb5cac549d397@localhost.talkaboutsoftware.com...
> I have created multicilumn listbox which display data from sheet1 range
> a1:d4.But in column c I have hyperlinks og when thix column is shown in
> listbox is shown as text not as hyperlink. How can I display hyperlink i
> multicolumn listbox?
>
>