Listbox Add to list

[Hank]

My list box is a list of names sorted a-z.
I would like to be able to type a name -not on the list- have it added to
the list and also sorted with the other names. Right now I can't add to
list.
Thanks

 

[Dick Kusleika]

Hank

How are you populating the listbox in the first place?

 

[Hank]

Dick,
I am using another sheet in the same workbook called MFG. The combo link is
to MFG!A2:A100. I do hide this sheet to prevent it from printing.
Thanks for your help
Hank

 

[Dick Kusleika]

Hank

I never use RowSource with listboxes. I only populate with AddItem (or
sometimes the List property) and I encourage everyone else to do the same.
Here are some web pages that may help you

Populating a Listbox
http://www.dicks-blog.com/excel/2004/05/populating_acti.html

Populating a Multi-column Listbox
http://www.dicks-blog.com/excel/2004/05/populating_mult.html

Populating from an unsorted range
http://www.dicks-blog.com/excel/2004/06/populate_a_mult.html

Sorting a ListBox
http://www.dicks-blog.com/excel/2004/05/sorting_listbox.html

Sorting a Multi-Column ListBox
http://www.dicks-blog.com/excel/2004/05/sorting_a_multi.html