ComboBoxes and Arrays

[JaneB19]

Hi,

I'm probably being really silly as it's Monday morning, but I'm having real problems binding an array to a comboBox in Excel 2000!

I've declared the array as:

Dim Div As Variant
Dim i As Integer

Div = Array("Value 1", "Value 2", etc)

For i = LBound(arDivision) To UBound(arDivision)
Sheet1.Division.AddItem Div(i)
Next i

Should this be in the Worksheet coding or the Workbook coding? Or am I doing this completely wrong?

Thanks in advance

Jane

 

[PHV]

Doesn't have your combo a RowSource property ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JaneB19]

Morning PHV, thank you for your reply!

Unfortunately it does not!

I've looked in the Properties window on the Excel spreadsheet, and also within the coding on the VBA side but nothing appears!

Any one got any ideas?

Thanks again

Jane