Combobox1.List = Range("A1:A100").Value

"Harinath" wrote in message
...
Hi All,

Please let me know some method for filling range of data to combobox on a
userform from spreadsheet.
The range data will be present on the spreadsheet.
I filled the combo by entering individual cell values in the VBA
code.Instead of doing like this
is there any method of selecting a range of values from a sheet and put
the same data into the combo in one go.

Please put some light on this.

Thanks
Harinath