I'm using Excel 2007 and I couldn't find the "Sorted" property
anywhere. Do listboxes in Excel 2007 have that property?

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




"GS" wrote in message
...

Suggestion:
Would using a 2-column listbox with its 'Sorted' property set to 'True'
work? If so then you could use InputBox to get values from the user. All
could be handled by the listbox's DoubleClick event.