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?
Romi MuharramAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Martin LissConnect With a Mentor Older than dirtCommented:
Please describe what it should do that it isn't , or what it should not do that's it's doing now.
1
 
Martin LissOlder than dirtCommented:
Try this version and if it's not what you want then please describe the problem(s) as I explained above.

BTW I change your topic from ACT to MS Excel and VBA.
28079408a.xlsm
1
 
Romi MuharramAuthor Commented:
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.
0
 
Martin LissOlder than dirtCommented:
OK, so if I've given the answer you need then please don't forget to close this question.
0
 
Martin LissOlder than dirtCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.