on 2/16/2011, Robert Crandal supposed :
I'm using Excel 2007 and I couldn't find the "Sorted" property
anywhere. Do listboxes in Excel 2007 have that property?

As I mentioned in my subpost, MSO listbox does not have this.


Also, if I have a 2 column listbox, how do I get data into the
2nd column? I can get data into column 1 with the following:

Me.Listbox1.AddItem "Apple" ' puts Apple in row 1, col 1
Me.Listbox1.AddItem "Orange" ' puts Orange in row 2, col 1
'
' etc.. etc...

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc