Test Value of ComoboBox in Userform|VBA & Macros|Excel Forum|My Online Training Hub

Hi,

Im doing a Hazard Module and one of the combo boxes that has a "yes" or "No"dropdown question.

The VBA userform formula below is what I wanted but doesn't seem to work well.

Private Sub Reg29_Change()
If Me.Reg29.Enabled = True Then
Me.Reg30.Text = "Not Entered"
End If
End Sub

So if Reg29 selects No then in Reg30 Textbox " Not Entered"

Or If Reg29 Selects Yes Reg30 textbox then blank.

Thanks

Steve