VBA Code to react to cell change, and apply value to another cell.

[Mclov1n88]

Tried searching but can not seem to find the right combination of search words so here it goes:

I am attempting to affect an option button to True, based on the status of other option buttons.

For example what I have started with

IF
ActiveSheet.DrawingObjects("Option Button 1").Value = True
THEN
ActiveSheet.DrawingObjects("Option Button 10").Value = True

---
Group 1 has 6 option buttons
Group 2 Has 2 option buttons

Desire would be

If Group one has option button 3 or 4 or 5 or 6 = True, then group 2 option button 1 true

Only trigger when group 1 buttons change, and no change needed when group 1 buttons 1 or 2 set to true




Hope that is enough to not be confusing.

 

[My Aswer Is This]

Tried searching but can not seem to find the right combination of search words so here it goes:

I am attempting to affect an option button to True, based on the status of other option buttons.

For example what I have started with

IF
ActiveSheet.DrawingObjects("Option Button 1").Value = True
THEN
ActiveSheet.DrawingObjects("Option Button 10").Value = True

---
Group 1 has 6 option buttons
Group 2 Has 2 option buttons

Desire would be

If Group one has option button 3 or 4 or 5 or 6 = True, then group 2 option button 1 true

Only trigger when group 1 buttons change, and no change needed when group 1 buttons 1 or 2 set to true




Hope that is enough to not be confusing.

Your subject title says:

VBA Code to react to cell change, and apply value to another cell.​

But then your posting only talks about Option Buttons