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?
|