evansjam
asked on
How would I get drop down (validation lists) within Excel to display its results alphabetically?
I am using drop down lists with Excel to list the contents of cells A3 to A30.
The contents of these cells are not in aphetical order, therefore are shown within the drop down list in the same, none alphabetical order.
I know that one solution to getting it in aphetical order is to simply re-arrange the date in cells A3 to A30. However, I have a few macro's running in the background of this and also some naming structures which would need altering also. As I am going to be expanding this selection, from A3 to A30 to A31 then A32 etc.
I wondered if there was some VB code which would automatically order the drop down list in aphetical order? if so, please will you help me?
The contents of these cells are not in aphetical order, therefore are shown within the drop down list in the same, none alphabetical order.
I know that one solution to getting it in aphetical order is to simply re-arrange the date in cells A3 to A30. However, I have a few macro's running in the background of this and also some naming structures which would need altering also. As I am going to be expanding this selection, from A3 to A30 to A31 then A32 etc.
I wondered if there was some VB code which would automatically order the drop down list in aphetical order? if so, please will you help me?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER