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