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 |
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 |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com