Hi I have used the form toolbar to add two radio buttons to my spreadsheet.
One is called OptionButton1_Click, the other is called OptionButton2_Click
I have a list in cells B4:B22 and the sum is calculated in cell B24.
I would like to use the radio buttons to allow me to do the following -
If OptionButton1_Click is cheked cells B7 & B8 will be discounted from the figure found in B24 and the figure in B6 will be included.
If OptionButton2_Click is checked cells B7 & B8 will be included in the figure found in B24 and the figure in B6 will be discounted.
It seems that excel automatically disallows having both selected so i am guessing I do not need to include this in my code.
Please can someone help me to code this. Thanks for any help you can offer.
Rob
Bookmarks