Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 84
  • Last Modified:

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?
0
Romi Muharram
Asked:
Romi Muharram
  • 4
1 Solution
 
Martin LissRetired ProgrammerCommented:
Please describe what it should do that it isn't , or what it should not do that's it's doing now.
1
 
Martin LissRetired ProgrammerCommented:
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 LissRetired ProgrammerCommented:
OK, so if I've given the answer you need then please don't forget to close this question.
0
 
Martin LissRetired ProgrammerCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now