To whom it may concern,

I am currently attempting to create an order form which allows the user to select a product using Combo-box's. I like this because they can begin to type the name of the product and have it auto populate, rather than searching a drop down menu for ages. I am also using a VLOOKUP based on what is selected in the Combo-Box to generate the item number. My issue right now is I cannot easily navigate between combo-boxes using enter or tab. Please understand this is my first day using developer tools so I am fairly behind the eight ball. The boxes function just like they should ( I have 21 of them in cells B14:B34 ). When I use the combo-box in cell B14 and begin typing my product name, it populates it perfect, however instead of just being able to hit enter to move to the next combo-box in B15, I have to use my mouse to click into the box to make it work correctly. I have used some different codes I found online. Some of them allowed me to hit enter to go to the next combo-box, however, the autofill would stop working. Does anyone out there have a solution?

Your help is greatly appreciated