ExcelBanter - Fill Listbox with Unique Items

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

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

- - Fill Listbox with Unique Items (https://www.excelbanter.com/excel-programming/385061-fill-listbox-unique-items.html)

Zone[_2_]

Fill Listbox with Unique Items

My userform has a listbox that I want to fill with unique items from a
column on my worksheet. What is the best way to do this? TIA, James

Tom Ogilvy

Fill Listbox with Unique Items

See this page at John Walkenbach's site:

http://www.j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items
--
Regards,
Tom Ogilvy

"Zone" wrote:

My userform has a listbox that I want to fill with unique items from a
column on my worksheet. What is the best way to do this? TIA, James

Zone

Fill Listbox with Unique Items

Very nice! Thank you, Tom (and John)! James

On Mar 12, 12:26�pm, Tom Ogilvy
wrote:
See this page at John Walkenbach's site:

http://www.j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items
--
Regards,
Tom Ogilvy

"Zone" wrote:
My userform has a listbox that I want to fill with unique items from a
column on my worksheet. *What is the best way to do this? *TIA, James- Hide quoted text -

- Show quoted text -

All times are GMT +1. The time now is 05:27 PM.