Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Validation
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Validation
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation | Excel Worksheet Functions | |||
Data validation with hyperlinks | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |