How do I change the order a cursor tabs through a form I have created?
I have a form created for ordering products. I have locked all cells except the ones I want them to enter data in (sheet protected). I want to be able to change the order the cursor moves in when they hit TAB.
- They will enter their name in the first cell available to them (C12)
- They then need to jump to the ordering part where they go to a Product Description cell (D19) where they can either select a product from a drop down list or start typing letters and the drop down list will narrow the field for them in that drop down list
- They then go to the Category cell (C19) and a drop down list will show the Product Category for the product they selected in D19
- They then go to the Code cell (B19) and a drop down list will show the Product Code for the product they selected in D19
- They then tab to an Additional Comments box (C31) to leave any comments.
Then separate buttons to review and submit the order.
At the moment, hitting tab moves from C12 to B19 to C19 to D19 to C31
I want the cursor to tab from C12 to D19 to C19 to B19 to C31
Can that be done?
[link] [comments]
Want to read more?
Check out the full article on the original site