Select the cell on the worksheet
ctrl-F3
give a name to the range

Fill in the rowsource in the properties of the Combobox this range name.

If the range change often see this page
http://www.contextures.com/xlNames01.html#Dynamic



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"shamsul" wrote in message ...
How do you choose a list of data from within an Excel
spreadsheet for a ComboBox created witin a UserForm?