Setting Tab order

[Rita]

I have created a complex invoice template using Excel. I would like to set
the order of tabbing if possible, so it goes from top to bottom on the left
and then top to bottom on the right for the top half of form and then the
same for the bottom half of form. Is there any way to set this up? Thanks!

 

[Rita]

I am using Excel 2007 and would like the easiest macro or solution possible,
because I won't be there to help if there is a problem.

 

[Rick Rothstein]

Is your "form" a UserForm? Is so, the VB editor has a tool for setting the
tab order; to get to it, click View/Tab Order on the VB editor's menu bar.
If not, what type of controls are you using (Form or ActiveX controls)? Or
are you talking about tabbing around in the cells themselves?

 

[Rita]

Thank you for answering. My form is just an excel spreadsheet that I have
made into a form/invoice. The data that is input will print out exactly like
it looks on the screen. After protecting the worksheet, I would like to tab
to the remaining cells in a certain order. I read somewhere about using
named range, but I didn't have any luck with that. Maybe I didn't understand
it. I am not very good with VB code, except for recording macros.

Maybe I should have made a userform, but this seems easier (what you see is
what you get). The people that will be using this don't have much excel or
computer knowledge. Thanks again.

 

[Rita]

Can anyone help me with this??

 

[Gord Dibben]

You could use a named range if you don't have more than about 45 cells to
move to.

Elsewise you will need VBA

Post the exact ranges and order of tabbing.


Gord Dibben MS Excel MVP

 

[Rita]

Thank you for your reply. I have at least triple that amount. Any other
easy ideas for a VB newby?? Thanks.

 

[Gord Dibben]

You will have to be a little more specific.

All we know now is that you want to fill cells top to bottom on the left
then top to bottom on the right on two halves of a worksheet.

Where is top and bottom on first half of form and top and bottom of second
half of form?

Where is right and left on both halves?

Sounds like 4 distinct ranges.

Please use cell addresses in your description.

Like A1:A20 and H1:H20 etc.

Are the cells contiguous in each range?


Gord

 

[Rita]

Here are my cells, sorry there are so many.

C3-C7, L3-L7, W3-W8, (A10, B10, C10, E10, J10, L10, U10, Repeat through 21),
A23, A25, C32, A34, B34, D34, B35, B36, H26-H30, H340H38)

Thanks so much for taking the trouble to help me. Also, I would need the
freedom to click on individual cells after the (script ?) is done.