I have created a form in Excel where I am asking user for specific contact
information for an order. My problem comes in that I have two contacts which
each need a name supplied, along with phone # and e-mail. Contact Name is
two merged rows, with Phone & Fax to the right, unmerged.

That is to say,
A16:J17 are merged,locked and say: Agency Contact.
K16:AB17 are merged, unlocked for " "
AC16:AF16 are merged,locked and say: Phone
AG16:AU16 are merged, unlocked for "
AC17:F17 are merged,locked for: E-mail
AG17:AU17 are merged, unlocked for "

And repeated on Row 18 and 19 for A/P Contact

I would like my tab order to be: K16,AG16,AG17,K18,AG18,AG19

Sorry to be so long winded, but I want to ensure that you see what I am
trying to accomplish.

Thanks in advance for any assistance.

Hi,

You will need to do that with a macro, because the order will be K16,AG16,
K16, AG17 by default.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RUSH2CROCHET" wrote:

I have created a form in Excel where I am asking user for specific contact
information for an order. My problem comes in that I have two contacts which
each need a name supplied, along with phone # and e-mail. Contact Name is
two merged rows, with Phone & Fax to the right, unmerged.

That is to say,
A16:J17 are merged,locked and say: Agency Contact.
K16:AB17 are merged, unlocked for " "
AC16:AF16 are merged,locked and say: Phone
AG16:AU16 are merged, unlocked for "
AC17:F17 are merged,locked for: E-mail
AG17:AU17 are merged, unlocked for "

And repeated on Row 18 and 19 for A/P Contact

I would like my tab order to be: K16,AG16,AG17,K18,AG18,AG19

Sorry to be so long winded, but I want to ensure that you see what I am
trying to accomplish.

Thanks in advance for any assistance.

Okay, I'm a bit of a "macro novice", and had already discovered the "default"
movement... Can you possibly assist with how to resolve?

TIA,
Sandi

"Shane Devenshire" wrote:

Hi,

You will need to do that with a macro, because the order will be K16,AG16,
K16, AG17 by default.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RUSH2CROCHET" wrote:

I have created a form in Excel where I am asking user for specific contact
information for an order. My problem comes in that I have two contacts which
each need a name supplied, along with phone # and e-mail. Contact Name is
two merged rows, with Phone & Fax to the right, unmerged.

That is to say,
A16:J17 are merged,locked and say: Agency Contact.
K16:AB17 are merged, unlocked for " "
AC16:AF16 are merged,locked and say: Phone
AG16:AU16 are merged, unlocked for "
AC17:F17 are merged,locked for: E-mail
AG17:AU17 are merged, unlocked for "

And repeated on Row 18 and 19 for A/P Contact

I would like my tab order to be: K16,AG16,AG17,K18,AG18,AG19

Sorry to be so long winded, but I want to ensure that you see what I am
trying to accomplish.

Thanks in advance for any assistance.