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!

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!

Hi

You will find some easy to follow instructions for using Data Validation
to achieve this on Debra Dalgleish's site
http://www.contextures.com/xlDataVal01.html

Debra also shows examples of how to use the Combo box as well.

--
Regards

Roger Govier


"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!