2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/AdComplete9707
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#no-code spreadsheet solutions
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#cursor order
#form
#tab key
#sheet protection
How do I change the order a cursor tabs through a form I have created?