xltrader100
New Member
- Joined
- Dec 8, 2009
- Messages
- 17
I have a list of names of pictures in a column on a sheet. When I click on any list item, the Selection_Change event loads the selected picture into a userform and displays it. This takes focus away from the clicked cell so I can't then select the next cell up or down with the arrow keys. The sheet stays active, the cell stays selected, but the only way to access the next list item is to click on it.
How can I bring focus back to the selected cell after displaying each picture so that the arrow keys will work?
How can I bring focus back to the selected cell after displaying each picture so that the arrow keys will work?