samanathon wrote in message ...
OK,
It didn't work, but let me specify a bit:
My worksheet has two userforms: Show_Information & Add_Airline.
Show_Information(userform) has: Airlines(combobox)
Add_Airline(userform) has Add_Airline(textbox) and Add_Airline(button)
So, the user wants to add a new airline to the Airlines(combobox). They
would click a button to load the Add_Airline(userform), enter info into
Add_Airline(textbox) and click Add_Airline(button).
Now, the new info has been entered into Airlines(combobox) on the
Add_Airline(userform).
Any ideas?
---
Message posted from http://www.ExcelForum.com/
In your Add_Airline userform, put the following click event for the
Add_Airline command button:
Private Sub cmdAdd_Airline_Click()
If txtAdd_Airline.Text < "" Then
Show_Information.cboAirlines.AddItem txtAdd_Airline.Text
txtAdd_Airline.Text = ""
txtAdd_Airline.SetFocus
End Sub
If you want to persist the airlines you will have to store them in a
sheet somewhere and initialize the combobox items with the existing
airlines.