L
Lisa C.
I have two radio buttons labeled "Yes" and "No" within the same group box. I
need a macro to run that hides rows when the "Yes" radio button is chosen and
that unhides rows when the "No" radio button is chosen. What do I need to do
to make the radio buttons automatically run the macro upon clicking them? I
don't know how to tie the macro to the two Yes/No radio buttons or what
syntax to use in the macro to recognize the radio buttons and the result of
Yes or No to make it run. Here is what I have but I'm missing the proper
syntax for the first line.
If [radio button???] = [??] Then
Rows("35:49").Select
Selection.EntireRow.Hidden = True
End If
If [radio button] = [??] Then
Rows("35:49").Select
Selection.EntireRow.Hidden = False
End If
need a macro to run that hides rows when the "Yes" radio button is chosen and
that unhides rows when the "No" radio button is chosen. What do I need to do
to make the radio buttons automatically run the macro upon clicking them? I
don't know how to tie the macro to the two Yes/No radio buttons or what
syntax to use in the macro to recognize the radio buttons and the result of
Yes or No to make it run. Here is what I have but I'm missing the proper
syntax for the first line.
If [radio button???] = [??] Then
Rows("35:49").Select
Selection.EntireRow.Hidden = True
End If
If [radio button] = [??] Then
Rows("35:49").Select
Selection.EntireRow.Hidden = False
End If