View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Williams[_4_] John Williams[_4_] is offline
external usenet poster
 
Posts: 12
Default Dynamically adding data to a Combobox?

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.