Solved

Excel Autofill Dropdown List with Combobox : How to make use of Tab and Enter key to input a value.

Posted on 2016-11-20
5
54 Views
Last Modified: 2016-11-27
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
Comment
Question by:Romi Muharram
  • 4
5 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 41894857
Please describe what it should do that it isn't , or what it should not do that's it's doing now.
1
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41894996
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
 

Author Comment

by:Romi Muharram
ID: 41898410
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
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41898427
OK, so if I've given the answer you need then please don't forget to close this question.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41903096
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question