I need excel 2007 vba coding to tab enter between regular cells and combo boxes

I’ve created an excel document in version 2007 with the ribbon (see attached document, both sheets that start with the word "Acct") that has numerous combo boxes in it and I’m in need of coding so the user can either use the tab or enter key to exit out of the combo box, rather than having to click out of them with their mouse, after they are done entering data. (and if you’re wondering why I went to the headache of creating combo boxes when I could of just used a validation list, there are too many restrictions on validation lists, like no autofill, for one and I needed something that would allow for numerous hours of data entry with ease ) My ultimate dream come true would be to have the user start in the most left hand field and be able to tab or enter to move over to the field directly to the right, regardless of whether that field is a normal cell or a combo box. If it happens to be a combo box they land in, I'd like the tab or enter key to "activate" (for lack of a better word) the combo box so that they can then start typing and autofil will do the rest. When they are done entering data, I would then like them to be able to hit the enter or tab key again and have their cursor move to the next cell to the right. Basically I don't want them to have to use their mouse for anything unless they choose to select an item from the dropdown box located within the combo box.

Anyway, I’ve researched online and understand that I need coding to use the tab and enter keys in a combo box. Problem is, I know NOTHING about code other than it exists (in fact if anyone posts a solution to this problem, you're probably going to give me detailed notes on how to get it in my document, as I don't even know how to do that )EXPENSE LOG TEST.xlsm I should probably mention that I’ve created nearly 500 combo boxes in this thing so it would be super helpful to have code that blankets the whole document (does this even exists?) rather than me having to go and individually attach the code to each combo box.


Any help someone can provide would be greatly appreciated. I think I've spent about 50 hrs on this thing and 20 of it has been researching this problem, trying to get it to work on my own with code I found online. I'm tired and just want to be done with this project. Thanks!

Hello lmisrasi,

Welcome to the Form!

When posting your workbook, please removing any protections prior to posting or supply the needed passwords in your post.

I noticed on your worksheet you are using Data Validation Drop Downs. Although these look like Combo boxes, they are very different animals. There are 2 basic types of Combo boxes: Forms and ActiveX.
The distinction is important to those reading your post. If a solution provided is for a Combo box, it will not work in your case. This will cause you more delays in solving your problem.

Hi lmisrasi

Welcome to the Form!

All the Code that's in Module1 belongs in the individual Worksheet Code Module in order for the Code to fire.

I'd guess you're using Code from here
http://www.contextures.com/xlDataVal11.html#Setup

I'll post a sample tomorrow...it works...let me know how I can help.

Hi lmisrasi

Play with the attached...see what works for you and what doesn't.

Hi lmisrasi

The Code is in both worksheets as is the TempCombo. It works for me on both worksheets...can't imagine why you're having an issue.

Hi lmisrasi

Please notice in the attached...I added Data Validation to Column M of #54004 and then, in the Worksheet Module for #54004, changed this line of Code

Please Login or Register  to view this content.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

lmisrasi,

This is a pre-set message so i didnt have to type it out. Sometimes 2 or more users tend to post at the same time as they wouldnt have refreshed the page while the other is posting. This is normal and happens here a lot.

Thank you for taking the required steps to close the loop on this thread.

Yeah, sorry...i wouldnt have checked the timing of your post.