If/Or and NULL logic

[Michael Island]

Hi,

I'm trying this but although it activates the Button it does not deactivate.

Why could this be?

Private Sub ComboBox1_Change()
If ComboBox1.Value = "United Kingdom" Or ComboBox1.Value = "United States" Then
CommandButton4.Enabled = True
End If
If ComboBox1.Value = Null Then
CommandButton4.Enabled = False
End If
End Sub

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

Or This...

Please Login or Register  to view this content.

Or this...

Please Login or Register  to view this content.

[Michael Island]

Thanks the last one worked a treat and suits my future needs.