Tab Order between Cells and Text Boxes
 

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?

Tab Order between Cells and Text Boxes
 

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


"kelli" wrote in message
...
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?