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
|