| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying the contents of a drop down list from the listbox itself? | Excel Discussion (Misc queries) | |||
| Making a Dynamic List in Listbox | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| ListBox List Code? | Excel Programming | |||
| Create ListBox (?) same as Find all Result List | Excel Programming | |||
![Hank[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
