If it is a user form you can use the RowSource property and give the name of the range. Kindly refer to this site
http://support.microsoft.com/kb/161598