Create a prompt so that once a selction is made no more selections can be made

[Dchav5]

I am trying to create a sales sheet so that when my broker selects a finish (i.e. color of the cabinets) in one cell, by placing a "x" in the corresponding cell, there is a prompt that comes up saying that no more selections can be made. I also don't want the broker to be able to insert another x in any of the other cells (in this case two other finish selections) for a total of 3 options. Your help is greatly appreciated.

 

[fred]

You can make "Option Buttons" on Developer tab.


Go to developer tab, Controls, Click on insert, choose Option buttons. or click F1 and search for option buttons.

 

[Dchav5]

Thanks. Working on it right now. When I right click and hit format control, there is no control tab, allowing me to link cells. Am I missing an add-on? Thanks

 

[fred]

Sorry I was working on something else while you wait.


You could be using ActiveX control which doesn't have a link cell. the option button should work even when there is no link cell associated with it. Is there a particular reason that you need to use the "control" tab?


If you need "control" tab then you need to look under "form control" on option buttons.

 

[Dchav5]

You were correct, I was using ActiveX. When I made the switch I was able to find the control tab and link the cell. The one last problem that I am having is that I want to create sections, i.e., kitchen cabinets, with three options below, kitchen countertops with three sections below. I can't seem to break it up so that when I select a kitchen cabinet, my kitchen countertop selection stays the same. Thank you so much!

 

[fred]

Use group box for each section.

 

[Luke M]

If the button idea doesn't work, a data validation rule like:

=COUNTIF(A$2:A$5,"x")<=1


might work.