Romi Muharram
asked on
Excel Autofill Dropdown List with Combobox : How to make use of Tab and Enter key to input a value.
This is a follow question to this threadCreating Dropdown with Autofill/Autocomplete in Excel.
Is it possible to make right/left arrow, or tab, or enter key act as it normally would without the drop down list?
Is it possible to make right/left arrow, or tab, or enter key act as it normally would without the drop down list?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what I needed.
So what I wanted was for the Tab and Enter key to function as it normally would in excel, since the combo box makes it unable to set cell value and move to the corresponding cell with that key.
Thanks a lot for your assistance.
So what I wanted was for the Tab and Enter key to function as it normally would in excel, since the combo box makes it unable to set cell value and move to the corresponding cell with that key.
Thanks a lot for your assistance.
OK, so if I've given the answer you need then please don't forget to close this question.
You're welcome and I'm glad I was able to help.
If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.
Marty - Microsoft MVP 2009 to 2016
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.
Marty - Microsoft MVP 2009 to 2016
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
BTW I change your topic from ACT to MS Excel and VBA.
28079408a.xlsm