View the Controls command bar and drag a combobox on to your
worksheet. Then right-click it, choose Properties and enter the
range in the ListFillRange property, e.g., Sheet2!A1:A10


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SMGray" wrote in message
...
Help! I would love to use a drop down field in my spreadsheet
without having
the data located on a separate sheet....I assume that the Combo
Box and or
List Box would do the trick....But I ABSOLUTELY can not figure
out how to use
them....CAN ANYONE HELP!?!? PLEASE!