Thank you both. Your advice was very helpful and answered my question.

"steve-o" wrote:

Hi :

I have about 700 items on a list. I want to create an excel sheet in which
our customers would go through the 700 items on the list and click off which
ones of these items they want. The choices are binary -either they want the
item, or they don't want the item.

Normally for this type of thing I would create a few checkboxes through the
checkbox control and link each checkbox to a cell. However, becuase the
number of items is so large, I don't think I would have the time or patience
to create 700 checkboxes and then associate them with cells.

So the next thing I did was create a data validation of a list where users
could go through each item, click on a cell, then see a drop down menu within
the cell with two options "X" and "" (Blank). However, my users told me they
don't want to click two times to make a selection (once to get to the cell,
and twice to select a choice within the drop down menu)

My question is- is there a way to replicate the feel of a checkbox within an
excel cell where one click on the cell sets the cell to a certain value , say
"X", and another click on the cell sets it to a different value, say "" .

Any help or guidance you could give me is greatly appreciated.

Thanks in advance,


steve-0