Hello.

I'm asking this question here because I'm not sure if there's a VBA
property that would control this or not.

Here's what I'm trying to do, and unfortunately I'm not that familiar
with the ComboBox Properties in VBA.

Essentially, I am using some ActiveX Comboboxes on a worksheet to
emulate the AutoFilter commands on another sheet.

I have been able to write all the proper procedures to do the filtering
on all the pages. (Not a problem.)

Where I run into trouble is when the Combobox is linked to a data list
where multiple values are the same. For example, a list may contain
values:

23
23
24
24
25
26
27

I only want unique values to show up in the Combobox (the same as they
would in Excel's regualr AutoFilter function:)

23
24
25
26
27

I have gone through the Properties on the ComboBox itself, but there's
nothing that limits this that I can find. Is there something in VBA
itself that will force the ComboBox to display only unique numbers from
the data list?

I hope I'm making sense. Any help would be greatly appreciated.

Thanks.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!