Thread: how to populate a combobox with a list of unique values?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how to populate a combobox with a list of unique values?
I think you'll have to cycle through the cells in that range (and dump the
..listfillrange assignment).

John Walkenbach shows a technique at:
http://j-walk.com/ss/excel/tips/tip47.htm

His example uses a listbox on a userform, but I bet you can change it to work on
your listbox on the worksheet.

RIOSGER wrote:

I just populated a combobox through listfillinrange property, just that the
column data source has repeated values... does any body would give me a clue
on how to filter just the unique vlaues on the combobox?

Thanks in advance and best regards!
Gerard!

--

Dave Peterson
Reply With QuoteReply With Quote