Sorting Validation

[Marten]

I have a dynamic validation list new entries will be entered here
continuously, but what i want is the drop down list to come sorted
alphabetically also when the linked list is no longer alphabetical? Could
anybody help?

Thanks
Marten

[Jim Cone]

Marten,

If your list of entries is a named range, then new entries inserted into it
will automatically adjust the range. So if your Validation list cell was "E5"
and the list was named "MyList" then the following event code in the
sheet module might do what you want...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$E$5" Then Range("MyList").Sort Range("MyList")
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Marten"
<[email protected]>
wrote in message
I have a dynamic validation list new entries will be entered here
continuously, but what i want is the drop down list to come sorted
alphabetically also when the linked list is no longer alphabetical? Could
anybody help?

Thanks
Marten