input value to textbox if combobox value = "test"

[sa3boool]

hi all

im new here.. i need help to make vba code for that .

=================================
combobox1 contain that word for example ( test1 : test 2 : test 3 )


if combobox1.value = "test1" then textbox1.value = "0" and show the text "0" in the textbox1

if combobox1.value = "test2:test3" then textbox1.value = ""

after that

Worksheets("test").Range("A1").Value = textbox1.Value
Worksheets("test").Range("B1").Value = combobox1.Value


==================================

any help to do that cod please !!

 

[My Aswer Is This]

Here is how you would write the code and put it in the ComboBox

Now the second part looks like you know how to do it.

Private Sub ComboBox1_Change()
'Modified  11/19/2020  11:04:35 PM  EST
If ComboBox1.Value = "Test1" Then
TextBox1.Value = "0"
Else
TextBox1.Value = ""
End If
End Sub