View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dogman_2000@hotmail.com is offline
external usenet poster
 
Posts: 1
Default How do I group data in an Excel Combo Box


I am using Excel 2002 and have several combo boxes on a worksheet.
Using 'ListFillRange' I have populated the contents of the Combo with
data from another worksheet.
The problem I have is that the 2 columns of data I am using have many
duplicates and I only want my users to see unique values.

Is there any way I can do this? I can't delete the duplicates because
there are other columns in my range with unique values.

Many thanks in advance.