Hi,
I'm using a column on a worksheet as the source for data validation for
another worksheet. The column used often contains double entries and the
worksheet it is in is always sorted using criteria in a separate column. The
result is that my Data Validation list is not sorted and contains duplicates.
Is there a method for extracting the list for Data Validation and having it
sorted A-Z using VBA? I should mention that the list is constantly being
modified.

Excel 97 on XP
--
Casey

There is no built in support for this (no checkboxes for unique values,
sorted).

You would need to construct a unique sorted list in another location and
make that the source for your data validation.


You could adapt this code from John Walkenbach's site to create the list:

http://www.j-walk.com/ss/excel/tips/tip47.htm


--
Regards,
Tom Ogilvy


"Casey" wrote:

> Hi,
> I'm using a column on a worksheet as the source for data validation for
> another worksheet. The column used often contains double entries and the
> worksheet it is in is always sorted using criteria in a separate column. The
> result is that my Data Validation list is not sorted and contains duplicates.
> Is there a method for extracting the list for Data Validation and having it
> sorted A-Z using VBA? I should mention that the list is constantly being
> modified.
>
> Excel 97 on XP
> --
> Casey
>
>

Thanks Tom.
--
Casey




"Tom Ogilvy" wrote:

> There is no built in support for this (no checkboxes for unique values,
> sorted).
>
> You would need to construct a unique sorted list in another location and
> make that the source for your data validation.
>
>
> You could adapt this code from John Walkenbach's site to create the list:
>
> http://www.j-walk.com/ss/excel/tips/tip47.htm
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Casey" wrote:
>
> > Hi,
> > I'm using a column on a worksheet as the source for data validation for
> > another worksheet. The column used often contains double entries and the
> > worksheet it is in is always sorted using criteria in a separate column. The
> > result is that my Data Validation list is not sorted and contains duplicates.
> > Is there a method for extracting the list for Data Validation and having it
> > sorted A-Z using VBA? I should mention that the list is constantly being
> > modified.
> >
> > Excel 97 on XP
> > --
> > Casey
> >
> >