The form that these list boxes on are not on a spreadsheet. I wanted this
workbook to look like an application.

"Joel" wrote:

Try putting the subaddress into the listbox. The display name of the
hyperlink (what you see on the spreadsheet) and the URL address are tow
different properties of a cell.

Sub test()
Set a = Range("C7")
MsgBox a.Hyperlinks.Item(1).SubAddress
End Sub


"gbpg" wrote:

I have several lsit boxes that move from one to another.The original
contained data that was hyperlinked (to external sources). When they are in
the list box the hyperlinks diappear. I want to keep this feature. Any ideas?