I have a user form (modeless) with option buttons (35) that input a value into the active cell.
I then have to click into another cell on sheet, then go back to option button.
What I would like to do to is ... move to the next cell using arrow keys or by vba, instead of clicking.
Can code be adjusted to allow this.
Sample of code
Please Login or Register to view this content.
Hi, dannac,
how do you know which is the next cell to select as ActiveCell? If there is a pattern in it you could amend your codes to move to that cell. And maybe even a control like a ComboBox could handle all your 35 Optionbuttons with only one code to update.
Example for filling in numbers in Columns A to E:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks