I have the current macro which makes false (unchecks) the option buttons when I leave and return to the active worksheet that they reside on.
Sub ClearOB()
Dim OB As OptionButton
For Each OB In ActiveSheet.OptionButtons
OB.Value = False
Next OB
End Sub
I do not want that. I want the option button values to be false when I change a cell value from a data validated cell on another worksheet to Apples or Carrots.
The worksheet that includes the option buttons is called Assumptions_Input.
The worksheet with the data validated cell is call Main Page and the cell C9.
The options buttons assume a false value whenever I leave the worksheet, the return to it (make it active).
Thank you for reading.
I appreciate all your help.
Bookmarks