Could anyone suggest how I might simplify the following. I have many comboboxes in a worksheet and I want it so that when someone is in the combobox and they press "enter" then you move to the next cell. Right now I make a vba code for each combobox and I know theres a simple way to cycle through them. Take a look at the code and let me know what you think.
Thanks!
This goes on until ComboBox 41.
Please Login or Register to view this content.
Hello Davo,
Are these ComboBoxes on a worksheet or a VBA UserForm? I am guessing worksheet. Add the code below to a VBA module in your workbook.
Please Login or Register to view this content.
Call the macro from each ComboBox_KeyUp event like this...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks