Hi Samantha
how about another alternative ... select the column where you want your list
box, choose data / validation, choose list
in the source line type
yes,no
and click OK
now click in one of the cells and you'll get a drop down arrow where you can
choose either yes or no - will this do?
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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