Hello I am trying to use an option button to select from a couple of different options. I am grouping car choice and then grouping transmission option. I am trying to allow someone to select an option and have it sum only the options selected and either gray out the other available options or clear the cell values from the other options. The scenario would be, once the option is selected a range of cells is summed and copied to a total at the bottom of the sheet. Last wondering how after the selection has been completed can clear the selected options and start over.

I am trying to use the ActiveX version of the option button but not sure how to set up.

Example

Option Button 1 (group a)
RED CAR
Black seats
Total $ 12000 cell (C5)

Option Button 2 (group a)
BLUE CAR
Black Seats
Total $ 12500 cell (H5)

Option Button 1 (group b)
Manual Transmission
Total $ 500 cell (L5)

Option Button 2 (group b)
Automatic Transmission
Total $ 950 cell (N5)


Total Price from both option groups $ xxxxxx cell ((Q5)