clear textboxes based on selected two ComboBoxes together on userform

[MKLAQ]

Hello
I use theses codes

Private Sub UserForm_Initialize()

  If ComboBox1.Value = and <> "" ComboBox2.Value <> "" Then
TextBox1.Value = ""
  TextBox2.Value = ""
  TextBox3.Value = ""
  end if 
End Sub

and

Private Sub ComboBox1_Change()
 If ComboBox1.Value <> "" And ComboBox2.Value <> "" Then
 TextBox1.Value = ""
  TextBox2.Value = ""
  TextBox3.Value = ""
 
  End If
 
End Sub

Private Sub ComboBox2_Change()
 If ComboBox2.Value <> "" And ComboBox1.Value <> "" Then
 TextBox1.Value = ""
  TextBox2.Value = ""
  TextBox3.Value = ""
 
  End If
 
End Sub

but doesn't work for me
my goal if I select items from two comboboxes should clear textboxes . if I select another item from combobox1 and the combobox2 is already selected item (not empty) then should clear all of textboxes ,if I select another item from combobox2 and the combobox1 is already selected item (not empty) then should clear all of textboxes .
any better way to do that
thanks in advance.

 

[My Aswer Is This]

now I understood why the error because in my project will there is items in resource from windows properties
so I can't use LIST properties for combobox I have to fill the items in comboboxes manually with this way. it's not practical totally

so you say from the first time will clear, but what if select another item from combobox1 and the combobox2 is already filled ? does work too?

I see nothing here.

 

[MKLAQ]

I see nothing here.

I don't understand it !

 

[My Aswer Is This]

I don't understand it !

Do you now have something that works for you?
And if so show us the script you're now using.

 

[MKLAQ]

based on OP
it works when select items from two both comboxes from the first time , but if I change selection another item from combobox1 and the combobox2 is already selected then doesn't clear textboxes .

 

[My Aswer Is This]

based on OP
it works when select items from two both comboxes from the first time , but if I change selection another item from combobox1 and the combobox2 is already selected then doesn't clear textboxes .

I wanted to see the code you're now using.
Not an explanation of the code you're using.

 

[MKLAQ]

I wanted to see the code you're now using.

the code in OP

Not an explanation of the code you're using.

I know if that work for you as you said based on the last explanation or not, but you don't answer me!

 

[jkpieterse]

Perhaps you can use a file sharing offering to send us a link to your (sanitized) file so we might have a closer look? Right now this feels like a stab in the dark.

 

[MKLAQ]

well, this procedure should be in the end after another code to populate in textbox . after populate if I select combobox2 then should clear.