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
|