I'm trying to build an order form and have figured out Combo Boxes as well as data validation formulas. The issue that I have is that I'm trying to use the combo boxes due to the predective text option, but it isn't recognized as linked to a particular cell so there is no way to set up an order form that is tab-able. I'd like to be able to use multiple combo boxes for Product Name "tab" Product Color "tab" Product Size "tab" Quantity. I would then copy those down on a single spreadsheet as one printable page.

I've done a lot of research and have hit a wall with this feature.

Any insight is appreciated.