Worksheet_Change event not running from Form control.
I put a radio button from the Control Tool Box on a sheet and put the code
below behind the sheet. I could not duplicate the problem. The option
button code triggered the change event each time.
Private Sub OptionButton1_Click()
If Range("B3") < 5 Then
Range("B3") = Range("B3").Value + 1
Else
Range("B3") = Range("B3").Value - 1
End If
Sheets(1).OptionButton1 = False
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("B3") Then
MsgBox "Bingo"
End If
End Sub
"Brad E." wrote:
I have a Worksheet_Change event set up and running great when I change cell
C7. Then I set up three (Form) radio buttons linked to C7. When I push the
radio buttons, C7 is changing, but the Worksheet_Change event doesn't get
called anymore. I know I could also assign a macro to the Form, but I want
to end up with 12 sets of 3 radio buttons, linked to 12 individual cells. It
would be easy to keep "Target" useful since these 12 cells are all over the
spreadsheet.
Thanks.
--
Brad E.
Many thanks to the people answering questions.
|