When "other" is clicked, some entry field component of some sort becomes visible, maybe
even modal, and when entry there is complete, this entry gets transferred to the listbox
and selected. It takes several components and some VBA of coding to do since you can't
type into a listbox.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"bostonlady " wrote in message
...
Does anyone know how to create a list box to allow the user to choose
AND allow the user to enter new data if he/she selects one item from
the list? For example "other" would allow the user to add an item.


---
Message posted from http://www.ExcelForum.com/