Hi:
In Excel, I want a combo box, which can control on each cell.

How can I do that?

Because after I create the combo box, then cell link is B1, then the
combo box only control B1 value, I want it control all cell like this:

___A_B
1____Y
2____N
3____Y
4____N
5...
etc..


How do I fix that? Thanks.

Thanks.


--
accessman2
------------------------------------------------------------------------
accessman2's Profile: http://www.excelforum.com/member.php...o&userid=27953
View this thread: http://www.excelforum.com/showthread...hreadid=474566