Not wishing to sound critical but what is wrong with the user just typing in
a Y or a N in the cell next to the item?
You could add some validation to the cells so that it only accepts Y or N.
Do you really need a combo box?

Nick




"Samantha" wrote in message
...

I need to set up something close to like this

1) Item Name / Does it play music? / yes or no (list box)

The problem I am having is I have 175 items I need that Yes or No box
in but I can't figure out how to do that.

So if someone could speak to me with instructions that a 7 year old
could understand as to how I can put 175 different combo or list boxes
in one worksheet that have the choices Yes or No..

Thank You for any help in advance.


--
Samantha