Thank you in advance for any guidance to this difficult request .
I have a list of 70 names in a column.
In essence, Only a single name is displayed or seen at a time on a large screen and the selected speaker is unknown until the name magically appears on the screen.
I hope this makes sense and again I thank each of you.
Mark
I have a list of 70 names in a column.
- I need to randomize this list and hide the names (I'm thinking white font color matching the background).
- Cell A1 would be blank. The starting position.
- Using the Enter key or down arrow key; as focus changes to each selected cell the data would be revealed (font color change) and really magnified pretty much filling the screen.
- As focus changes to the next cell the previous cell would be changed back to "hidden".
In essence, Only a single name is displayed or seen at a time on a large screen and the selected speaker is unknown until the name magically appears on the screen.
I hope this makes sense and again I thank each of you.
Mark