I have created a form which has a combobox, a text box and a submit button. I want that a person should choose an item from combo box, enter a number in text box and then when one clicks submit button, the value in combo must be checked for in a cell or a range (I tried cell as ranged looked a bit complicated) and if the value selected form Combo box is equal to the value in the cell specified( or is present in the range), then, it should go to another sheet and add the value inside text to an existing value in a specific cell (that is the range name).
I coded like this:
Private Sub CommandButton1_Click()
With UserForm2
If ComboBox1.Value = Worksheets("Sheet3").Range("D2").Value Then
Set j = UserForm2.TextBox1.Value
Worksheets("Sheet4").Range("B2") = Worksheets("Sheet4").Range("B2") + j
End If
End With
End Sub
Unfortunately, I am stuck and unable to understand the error, it says object missing...which object is it talking about?
Please help me with this coding
Bookmarks