cboBox to read data from a spreadsheet Range
 

With Worksheets("Sheet1")
varr = .Range("A1:A12").Value
End with

Combobox1.List = varr


or do it directly

With Worksheets("Sheet1")
Combobox1.List = .Range("A1:A12").Value
End with

Regards,
Tom Ogilvy


"Igor" wrote in message
...
Hi,

I have a comboBox on the form, and i want it to read data
array from the spreadsheet.
Lets say i have months listed in cells A1:A12, how do i
make combo box read from that.

Thank you