Can you explain the difference & How to use: Combo Box/List Box?

[SMGray]

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!

[Chip Pearson]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Roger Govier]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!