Excel combobox problem 1

[GBall]

Hi,
I'm tryinmg to populate a combobox I've created in a worksheet with the following code.

i = 0
Do While Not x.EOF
Sheet2.ComboBox3.Column(i, 0) = x!type_id
Sheet2.ComboBox3.Column(i, 1) = x!type_name
Sheet2.ComboBox3.Column(i, 2) = x!type_desc
i = i + 1
x.movenext
Loop
Pretty simple ?
However, the first time through I get:-
Runtime error 381
could not get the column property
Invalid property array index.

Same happens in debug if I type
?sheet2.ComboBox3.column(0) or (1)
I've defined the combobox with 3 columns.

What am I doing wrong ?


Regards,
Graham

 

[Stretchwickster]

Maybe the index starts from 1 rather than 0?

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[TonyJollans]

Hi Graham,

A combobox has an array of columns (across) by items (down). As well as declaring the columns, you must add the items before you can reference the individual cells. I think you need to put Sheet2.Combobox3.AddItem as the first line inside your Do loop to create the row (list item) you are trying to populate.

Enjoy,
Tony

 

[GBall]

Thanks Tony, bang on!
Sorry for the delay in getting back - long weekend.

Regards,
Graham