how to set commandbutton.enabled=true with conditions for both combobox and textbox <> ""

[zhouyiqing]

I have a userform with one combobox, one textbox and one commandbutton, trying to figure out how to set commandbutton.enabled=true only if only there're contents in both combobox and textbox (<>""). I've tried:
----------------------------------------
Private Sub Textbox1_Change()
If TextBox1.Text <> "" And UserForm1.ComboBox1.Text <> "" Then
CommandButton1.Enabled = True
Else
CommandButton1.Enabled = False
End If
End Sub
---------------------------------------
But when user fill-in data in textbox, then select content from combobox, it doesn't work, only when user fill-in more data in textbox it works.
Thanks in advance.

[john55]

try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[:) Sixthsense :)]

Try something like this...

Please Login or Register  to view this content.

[zhouyiqing]

awesome! exactly solved my problem, thanks both of you!