ExcelBanter - Populating a List Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Populating a List Box (https://www.excelbanter.com/excel-programming/398446-populating-list-box.html)

Eric

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

Tom Ogilvy

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

All times are GMT +1. The time now is 03:35 AM.