I have a checkbox macro that calls a macro when its on and calls a different macro when its off. The macro is as follows:
Sub OxygenCheckBox()
Dim cb As Excel.CheckBox
Set cb = Excel.ActiveSheet.CheckBoxes(Application.Caller)
If cb.Value = xlOn Then
Call YesOxygen
Else
Call Oxygen
End If
in addition to calling these macros, I want the checkbox to place "0" in a range of cells when checked (E280:E285), and when unchecked I want cells E280:E285 to display its normal formulas. Is there anyway to do this? Thank you for any help.
Sub OxygenCheckBox()
Dim cb As Excel.CheckBox
Set cb = Excel.ActiveSheet.CheckBoxes(Application.Caller)
If cb.Value = xlOn Then
Call YesOxygen
Else
Call Oxygen
End If
in addition to calling these macros, I want the checkbox to place "0" in a range of cells when checked (E280:E285), and when unchecked I want cells E280:E285 to display its normal formulas. Is there anyway to do this? Thank you for any help.