Combobox with two columns

[Bob Phillips]

xld

How does it show the concept of populating a combobox from a table/query?

It doesn't, because that wasn't the question. Michelle asked

Can you pls tell me how to fill my combobox and what properties I have to set for the combobox

This doesn''t work!

With ComboBox1
    .AddItem "Create Button", 1
    .AddItem "Remove Button", 2
End With

.

So I did, in very general VBA terms.

By the way I fully understand the AddItem method.

Did I say otherwise?

No need for a loop.

ary = [{"Bob","M", 123;"Lynne","F",898;"Amy","F",543}]
ComboBox1.ColumnCount = 1
ComboBox1.List = ary

No there isn't and that works too, but I chose to use the other method so that Michelle mioght get a deeper understanding of what was happening, as she was not quite up to speed on it. That was my choice, and I made it.

ary = [{"Bob","M", 123;"Lynne","F",898;"Amy","F",543}]
ComboBox1.ColumnCount = 3
ComboBox1.Column = ary

She only wants one visible column, so don't set ColumnCount to anything other than 1.