|
Listbox Add to list
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 |
Listbox Add to list
Hank
How are you populating the listbox in the first place? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Hank" wrote in message ... 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 |
Listbox Add to list
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" wrote in message ... Hank How are you populating the listbox in the first place? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Hank" wrote in message ... 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 |
Listbox Add to list
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...ting_acti.html Populating a Multi-column Listbox http://www.dicks-blog.com/excel/2004...ting_mult.html Populating from an unsorted range http://www.dicks-blog.com/excel/2004...te_a_mult.html Sorting a ListBox http://www.dicks-blog.com/excel/2004...g_listbox.html Sorting a Multi-Column ListBox http://www.dicks-blog.com/excel/2004...g_a_multi.html -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Hank" wrote in message ... 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" wrote in message ... Hank How are you populating the listbox in the first place? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Hank" wrote in message ... 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 |
| All times are GMT +1. The time now is 11:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com