View Single Post
  #4   Report Post  
JulieD
 
Posts: n/a
Default

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