| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating a List Box
How can I populate a list box with a range of cells but some of the numbers
in the cells are duplicates. Ie: Range 456 456 123 123 I want the list box to show only one(1) 456 and only one(1) 123. Is this possible? What does the macro look like? I do not know what numbers I will need because they change weekly. So I can't us the addItem command. Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populating a List Box
http://www.j-walk.com/ss/excel/tips/tip47.htm
-- Regards, Tom Ogilvy "Eric" wrote: How can I populate a list box with a range of cells but some of the numbers in the cells are duplicates. Ie: Range 456 456 123 123 I want the list box to show only one(1) 456 and only one(1) 123. Is this possible? What does the macro look like? I do not know what numbers I will need because they change weekly. So I can't us the addItem command. Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
| populating a list box | Excel Programming | |||
| Populating List Box from SQL Server | Excel Programming | |||
| populating list | Excel Programming | |||
| Populating dropdown list 2 with data depending upon what was selected in list 1 | Excel Programming | |||
Linear Mode
