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!

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.

"Rita" wrote:

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!

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?

--
Rick (MVP - Excel)


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

"Rita" wrote:

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!

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.

"Rick Rothstein" wrote:

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?

--
Rick (MVP - Excel)


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

"Rita" wrote:

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!

Can anyone help me with this??

"Rita" wrote:

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!

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

On Mon, 6 Apr 2009 11:21:01 -0700, Rita
wrote:

Can anyone help me with this??

"Rita" wrote:

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!

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

"Gord Dibben" wrote:

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

On Mon, 6 Apr 2009 11:21:01 -0700, Rita
wrote:

Can anyone help me with this??

"Rita" wrote:

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!

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


On Mon, 6 Apr 2009 14:36:08 -0700, Rita
wrote:

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

"Gord Dibben" wrote:

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

On Mon, 6 Apr 2009 11:21:01 -0700, Rita
wrote:

Can anyone help me with this??

"Rita" wrote:

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!

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.

"Gord Dibben" wrote:

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


On Mon, 6 Apr 2009 14:36:08 -0700, Rita
wrote:

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

"Gord Dibben" wrote:

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

On Mon, 6 Apr 2009 11:21:01 -0700, Rita
wrote:

Can anyone help me with this??

"Rita" wrote:

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!