Shansul,

In code
ComboBox1.RowSource = "Sheet1!A1:A5"

or goto the properties window of the combobox and set the Rowsource
Sheet1!A1:A5

You can also define a name for the list and use the name instead of the
range.
--
sb
"shamsul" wrote in message
...
How do you choose a list of data from within an Excel
spreadsheet for a ComboBox created witin a UserForm?