xltrader100
New Member
- Joined
- Dec 8, 2009
- Messages
- 17
My objective is to be able to use the up/down Arrow keys to step down a list of names in a column. Each step up/down puts a new picture into a Userform, which stays visible and floating above the sheet.
All of that works fine if I use the mouse to click on the next cell up or down, but when trying to use the Arrow keys the problem is that as soon as the picture gets loaded onto the form, the form takes focus, and the next Arrow keypress doesn't register until the sheet regains focus.
I'm looking for a VBA command that can bring the sheet back into focus, as if I clicked on the border of the sheet.
All of that works fine if I use the mouse to click on the next cell up or down, but when trying to use the Arrow keys the problem is that as soon as the picture gets loaded onto the form, the form takes focus, and the next Arrow keypress doesn't register until the sheet regains focus.
I'm looking for a VBA command that can bring the sheet back into focus, as if I clicked on the border of the sheet.