Listbox Add to list

H

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
 
H

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
 
D

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
 
Top