View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default ListBox and Hyperlinks

"RK" wrote ...

Well, all that seams to do is make the ListBox bigger,
but still displays empty.


I thought you may have made one of your columns zero width i.e. not
visible. You did in earlier code:

http://groups.google.com/groups?selm...0a%40p hx.gbl

Me.ListBox1.ColumnWidths = "0;1"

But this is just one of a number of listbox properties that affect
whether columns are visible. Take another look at MSDN.

Have you tried to create a hyper-link to a couple of
spreadsheets and tried this? You will see what I mean.


Yes, the following code works for me:

http://groups.google.com/groups?selm...g .google.com

Jamie.

--