Tabbed cells

[Colette]

Hi

Can someone possibly help me

I have a form that I would like the user to tab to the next available cell
within a certain part like the Supplier Name & Address which goes downwards
for five cells then move across to the right to the Delivery address for five
cells going down instead of from left to right as in any protected worksheet
with unlocked cells - is there a formula or VBA that is written for this
please?

Many Thanks in Advance for any help

 

[joel]

You would need a macro. Macro can be programmed to use the Tab key o
any key you want to use. the row numbers are important in writing th
code since you would want to move down 5 row (need exactly the ro
numbers) and then move back to the first row in another column. I woul
need know the pattern of you data in the userfrom to write a macro.


I don't know if you have a Worksheet Userform or a VBA Userform. Th
VBA Userform has a tab order propery to sequnce through a group o
objects (ie textboxes) to go through the boexes in a specific order.
worksheet userform doesn't have this option and you have to write
simple macro to handle the tabl key.


I also don't know if you have multiple form on the same sheet so you
1st form may be in rows 1 - 10 and the next form in rows 10-20. th
macro would be slightly different depending on the exact arrangement o
data.

 

[Colette]

Hi Joel

Thanx for your quick response:

It's a worksheet Userform and it's all on one page

To be able to write a macro would I need to include all of the unlocked
cells within the form or can it tab down until it gets to the Supplier and
Delivery addresses and then the macro can kick in? I've also got four check
boxes, will these need to be included in the macro?

The cells are referred to previously in my message are:

Supp1, Supp2, Supp3, Supp4 (sorry four cells not five) and then across to
Del1, Del2, Del3 and Del4

But previous to these there is three unlocked cells and after that many more

Any help will be appreciated Joel

Colette