Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamically Adding Textbox To Frame | Excel Worksheet Functions | |||
creating a combobox dynamically on an excel sheet | New Users to Excel | |||
Emergency ( Adding Worksheets dynamically in Workbookds) | Excel Programming | |||
Program a combobox/dropdownlist to create textboxes dynamically | Excel Programming | |||
Adding button dynamically | Excel Programming |