I'm trying my hand at VBA.
I have a statement that says:
Sub PM() Set rn = ActiveWindow.VisibleRange.Cells(1, 1) Application.ScreenUpdating = False 'If Not Intersect(Target, Range("C27")) Is Nothing Then If Range("C27") = 3 Then ActiveSheet.Shapes("Option Button 28").Select Selection.Enabled = False If Range("J57") < 455 Then Range("J56") = False Else Range("J56") = True End If Else ActiveSheet.Shapes("Option Button 28").Select Selection.Enabled = True End If rn.Activate Application.ScreenUpdating = True End Sub
When I change cell C27, the value passed to cell J56 works perfectly. But once the value in C27 is chosen, and I then change cell J57, J56 doesn't change accordingly as it should. I have to change C27 value again to trigger J56 to reflect the right value.
Can anyone point out what I'm doing wrong?