Thread: Listbox problem
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_2_] Robert Crandal[_2_] is offline
external usenet poster
 
Posts: 158
Default Listbox problem


.. My sample file shows how to do this. It uses a 2 col listbox w/Col2 as
Boundcolumn. User only sees names in the list (sorted) because Col2 width
is zero.


Thanks so much for the demo. It is much appreciated.

In looking at your code, it appears that you are populating the multi-column
listbox with the following code:

Me.ListBox1.list = vItemList

Is "vItemList" a "Worksheet" type of variable that corrosponds to data
on the worksheet? (I'm still kinda newbie with VBA, so I just wanted
to verify)

Also, is that the ONLY way to fill in a 2 column listbox,
by passing a Worksheet/range to the ".list" property?? What if I have
data that doesn't exist on the worksheet and I want to put that data into
a 2 column, n-rows listbox?? For example, what if I have a mult-dim array
of strings....can I use this data to fill in my multi-column listbox?