Sunday, August 7, 2011
How can I move to the next cell from a combo box control by pressing the enter/tab key without using VBA?
I'm using the combo box under control toolbox in excel. After I've selected an item from the dropdown list, I press enter or the tab key but the cursor still remains in the combo box. I can only move to another cell by using my mouse to click on the cell I want to go. I want to use the tab/enter key just like a normal excel spread sheet to navigate around. I'm not an experienced excel user so I do not know VBA. Is there a way to do it without using VBA? If not, would you let me know the VBA code to use and explain to me where I have to change to fit for my use. Thanks a lot for your help!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment