VBA - trigger macro when radio button is selected

Question

I am having trouble running a macro automatically when I select a radio button option. There are two radio-button options, which are linked to the cell named "SimType" on the sheet codenamed "MAIN". I have adapted the following code from MSDN and have included it in the module for the MAIN worksheet but cannot get it to function:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range
    Set KeyCells = Range("SimType")
    If Not Application.Intersect(KeyCells, Range(Target.Address)) Is Nothing Then
       RefreshSimsList 
    End If
End Sub

I understand Target refers to the ActiveCell so when I manually enter values of 1 or 2 into Range("SimType"), the macro triggers. However, when the cell is altered by the linked radio-buttons, no action is triggered. What can I do to have the sheet recognize that the value has been changed without it being the ActiveCell?

Unfortunally you will not be enable to do this using a form control. To capturing a radiobutton click event you should use an ActiveX control (RadioButton). — Roger Barreto
– Roger Barreto, Commented Apr 4, 2014 at 16:26

Siddharth Rout · Accepted Answer · 2014-04-04 16:00:56Z

2

Place this code in a module

Sub OptCommon()
    '
    '~~> Rest of the code
    '
End Sub

And simply right click on both the option button and assign macro to it. Now not only the cell value will change but the macro will also run.

answered Apr 4, 2014 at 16:00

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA - trigger macro when radio button is selected

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related