Hi, Just one more piece of info from you:
How Airlines(combo) gets its list of choices? Is it named range? Is it
loaded through .AddItem? Is it empty at present?
I will then have an answer.

However, like you, I'd be happy to see most elegant solution.
I mean the solution that doesn't involve AddAirline form - just plain typing
away new (unmatched) text in Combo invokes MsgBox, asking if OK to add new
stuff in.
regards
Paul
U¿ytkownik "samanathon " napisa³
w wiadomo¶ci ...
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/