palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have two drop-down lists, the first chooses which year level the user wishes to choose from, the second populates with students who belong to the year level chosen in the first drop-down list .. see below ...
If I make a choice of student, (for example .. Laila Brighton), it will, of course, display that student name, however, if I return to choose a different student name, the drop-down list will only show the names in the list from Laila Brighton down .. in other words, any name higher than that name will not be shown unless I deliberately scroll back up to see them.
This becomes a problem, of course, when I choose a name right down the bottom of the list, so if I return to choose another name, only the very bottom name(s) would be displayed.
Now if I'm the only user, that's not an issue as I know to scroll back up, however, the spreadsheet is accessed by a large number of teachers, most of whom have little excel knowledge, so inherently if they choose a name down the bottom of the list, when they return to choose another name from that same year level, they think the drop-down list has no names to offer ... they don't know to scroll back up to find the other names.
So ... is there a way to force the drop-down list to ALWAYS return to the top of the list each time it's accessed ?
Important : I would like to avoid using combo boxes as they tend to have other issues, such as expanding and shrinking depending on the resolution of the user's monitor etc.
I'd like to stick with drop-down lists with data validation if at all possible.
Can this be done ?
Very kind regards,
Chris
If I make a choice of student, (for example .. Laila Brighton), it will, of course, display that student name, however, if I return to choose a different student name, the drop-down list will only show the names in the list from Laila Brighton down .. in other words, any name higher than that name will not be shown unless I deliberately scroll back up to see them.
This becomes a problem, of course, when I choose a name right down the bottom of the list, so if I return to choose another name, only the very bottom name(s) would be displayed.
Now if I'm the only user, that's not an issue as I know to scroll back up, however, the spreadsheet is accessed by a large number of teachers, most of whom have little excel knowledge, so inherently if they choose a name down the bottom of the list, when they return to choose another name from that same year level, they think the drop-down list has no names to offer ... they don't know to scroll back up to find the other names.
So ... is there a way to force the drop-down list to ALWAYS return to the top of the list each time it's accessed ?
Important : I would like to avoid using combo boxes as they tend to have other issues, such as expanding and shrinking depending on the resolution of the user's monitor etc.
I'd like to stick with drop-down lists with data validation if at all possible.
Can this be done ?
Very kind regards,
Chris