Tab Order between Cells and Text Boxes

K

kelli

I have a spreadsheet with many locked cells. The only unlocked cells are
those which the user can type into. But this same spreadsheet also has
textboxes that can be typed in. The locked cells have a great tab order and
the same for the textboxes, but I need them to be interspersed. For example,
cell, cell, cell, textbox, textbox, cell, textbox. How can I get the tab
order correct for all of them?
 
H

Harald Staff

This is close to impossible unless you are a very good macro writer, if so
it's just very complicated. These tasks are far better done with userforms.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Locked cells are still able to be selected with proper protection 1
Tabbing Order of Unproteced Cells 3
Locked cells in Excel 2000 1
Setting the Tab Order 3
Form built in Excel 1
Locked Cells & List Boxes in Template 5
Problems with macro, setting "tab order" of unprotected cells 3

Top