Hi all! Hope life is treating you all well!
I have problems with my combobox (in a userform). It works properly when I select a value. It fills the concerning cell in the worksheet with that value.
But if nothing is selected in that combobox, the cell which once was filled with a value becomes empty again.
I just want that when no value is selected in the combobox the cell stays as it is (so the combobox doesn't do anything).
Code
Worksheets("Data").Activate
ActiveCell.Offset(0, i).Range("AG1").Select
ActiveCell.Value = UserForm1.ComboBox2.Value
UserForm1.ComboBox2.Value = vbNullString
sorry for my english