I have a userform with the code below. You can see I have "shut off" part of
the code. When the userform activates it is supposed to enable a continue
button if certain conditions are met. However, when it activates the command
button it also fires it (the code in the command button closes the userform
and opens the next userform). This is so strange???

Public Sub UserForm_Activate()
Set WSCal = Sheets("Cal")
WSCal.Range("HealthAnswerRange,HealthCmt2").ClearC ontents
With usfHealth
.cmbCt.Enabled = False
' If .chbxKid = True Or .chbxHeart = True Or .chbxEye = True Or
..chbxA1C = True Or _
' .chbxStroke = True Or .chbxAmputation = True Or .chbxFoot = True Or
..chbxGlucose = True Or _
' .optbutNone = True Then .cmbCt = True
' .lblHealth.Caption = WSCal.Range("HealthQ")
End With
Application.ScreenUpdating = False
End Sub


--
Thanks
Shawn