Hi all,
I'm trying to create a simple userform with combobox values then allows user to add new items and save the items( in the sense the values that you key values into the textbox and both combobox1 and combobox2 gets updated and remains after closing and opening the excel file). Here is my code:
Private Sub ComboBox1_Change()
End Sub
Private Sub ComboBox2_Change()
End Sub
Private Sub CommandButton1_Click()
Me.ComboBox2.AddItem Me.TextBox1.Value
Me.ComboBox1.AddItem Me.TextBox1.Value
Me.TextBox1.Value = ""
MsgBox "Category added to combobox!!"
End Sub
Private Sub UserForm_Activate()
Me.ComboBox1.AddItem "Chicken"
Dim sh As Worksheet
Dim i As Integer
End Sub
I will appreciate any help.