-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to Sort Values showed in a List Box
- Thread starter FlavioT
- Start date
I would create a query that will give me the info for the list box and sort it ascending. Have the list box be linked to that. It should appear the way you want.
There might be a simpler way to do this, but this is all I can come up with.
Parra
There might be a simpler way to do this, but this is all I can come up with.
Parra
Upvote
0
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Quick comment on sorting. In an Acess query you can sort on as many fields as you want, but the highest priority is on the fields at the left.
Say you have an ID, a Name, a State and a Date Joined field. If you don't apply a sort, the ID is used by default. By placing Ascending or Descending under the other fields, you set the sort order -- and if the ID field has no sort assigned, Name will be the first priority in teh above scheme.
Denis
Say you have an ID, a Name, a State and a Date Joined field. If you don't apply a sort, the ID is used by default. By placing Ascending or Descending under the other fields, you set the sort order -- and if the ID field has no sort assigned, Name will be the first priority in teh above scheme.
Denis
Upvote
0
Similar threads
