PDA

View Full Version : Value of Multi column combobox



zagrijs
10-30-2011, 01:54 AM
I have a multi combobox that lists Surname, Initials and Title from three columns on a worksheet. However, only the value of the first column, "Surname", is given when I read the value. Is it possible to access the values of all the columns simultaneously? If so, how is it done?

All assistancae appreciated.

Regards

Zagrijs

Macrosian
10-30-2011, 03:34 AM
Try..ListBox1.List(ListBox1.ListIndex, 1)
ListBox1.List(ListBox1.ListIndex, 2)

mikerickson
10-30-2011, 08:11 AM
Set the .BoundColumn property of the ComboBox to 1 and the .TextColumn property to 2.

Then MsgBox ComboBox1.Text & " " & ComboBox1.Value will give the person's surname and initials.

For more than two columns, Macrosian's approach of accessing both dimensions of the .List property is needed.

zagrijs
11-02-2011, 01:36 AM
Thanks. The help is appreciated