How do I make the cursor got to a specific cell in a worksheet? The
worksheet is for others to enter data and some cells are locked - I want the
user to simply be able to hit the enter key and go to the next cell that
needs data entered - in sequence - Any help with what I thought would be
simple is appreciated!
--
micah

Hi,

Since you say some cells are locked then when you apply the protection only
check the box to Select Unlocked cells. (Uncheck the box Select locked cells.)

You will need to Unprotect and reapply Protect to do this.

Regards,

OssieMac

"micah" wrote:

How do I make the cursor got to a specific cell in a worksheet? The
worksheet is for others to enter data and some cells are locked - I want the
user to simply be able to hit the enter key and go to the next cell that
needs data entered - in sequence - Any help with what I thought would be
simple is appreciated!
--
micah

I guess I need to explain mo They enter information from D2:D10 then when
they hit the enter button after inputting data in D10 I want the cursor to
jump to J4 and type in data then when they hit enter have the cursor jump to
C14 .... there are several jumps within the sheet. In Access you would just
set up a tab order, but this customer wants this form in Excel. Any
suggestions?
--
micah


"micah" wrote:

How do I make the cursor got to a specific cell in a worksheet? The
worksheet is for others to enter data and some cells are locked - I want the
user to simply be able to hit the enter key and go to the next cell that
needs data entered - in sequence - Any help with what I thought would be
simple is appreciated!
--
micah

Hi again,

Someone might be able to suggest a better idea but it would be possible to
set up a worksheet change event with a Select Case so that each time a value
is entered then the cursor would jump to a specified cell relative to the
last cell changed. However, it relies on an actual change. If no entry made
and the user presses Enter then nothing occurs.

If you are interested and you want me to write the code then let me know and
provide a list of the cell addresses to change in their correct order. (Not
too difficult for you to adjust if the order is not correct.)


Regards,

OssieMac



"micah" wrote:

I guess I need to explain mo They enter information from D2:D10 then when
they hit the enter button after inputting data in D10 I want the cursor to
jump to J4 and type in data then when they hit enter have the cursor jump to
C14 .... there are several jumps within the sheet. In Access you would just
set up a tab order, but this customer wants this form in Excel. Any
suggestions?
--
micah


"micah" wrote:

How do I make the cursor got to a specific cell in a worksheet? The
worksheet is for others to enter data and some cells are locked - I want the
user to simply be able to hit the enter key and go to the next cell that
needs data entered - in sequence - Any help with what I thought would be
simple is appreciated!
--
micah

Sounds Great - better than any idea that I have been able to come up with or
research! If you can get me started I think I can add all of the in between
since there are so many, but here is the start of it:

d1, d2, d3, d4, d5, d, d7, d8, d9, j4 j5, c14, 15, c16, c17, c18, f14.......

Thanks for your help - I've been working on this all night and need to get
it done before 3 today if possible!
--
micah


"OssieMac" wrote:

Hi again,

Someone might be able to suggest a better idea but it would be possible to
set up a worksheet change event with a Select Case so that each time a value
is entered then the cursor would jump to a specified cell relative to the
last cell changed. However, it relies on an actual change. If no entry made
and the user presses Enter then nothing occurs.

If you are interested and you want me to write the code then let me know and
provide a list of the cell addresses to change in their correct order. (Not
too difficult for you to adjust if the order is not correct.)


Regards,

OssieMac



"micah" wrote:

I guess I need to explain mo They enter information from D2:D10 then when
they hit the enter button after inputting data in D10 I want the cursor to
jump to J4 and type in data then when they hit enter have the cursor jump to
C14 .... there are several jumps within the sheet. In Access you would just
set up a tab order, but this customer wants this form in Excel. Any
suggestions?
--
micah


"micah" wrote:

How do I make the cursor got to a specific cell in a worksheet? The
worksheet is for others to enter data and some cells are locked - I want the
user to simply be able to hit the enter key and go to the next cell that
needs data entered - in sequence - Any help with what I thought would be
simple is appreciated!
--
micah

See Bob Phillips' site for a couple of methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

The named range will probably suit but.........?

There is another method using sheet event code and Select Case to control Tab
order.

If interested post back.


Gord Dibben MS Excel MVP

On Mon, 29 Oct 2007 04:46:01 -0700, micah
wrote:

Sounds Great - better than any idea that I have been able to come up with or
research! If you can get me started I think I can add all of the in between
since there are so many, but here is the start of it:

d1, d2, d3, d4, d5, d, d7, d8, d9, j4 j5, c14, 15, c16, c17, c18, f14.......

Thanks for your help - I've been working on this all night and need to get
it done before 3 today if possible!

THANKS! That helped get me started - just an FYI - instead of entering all of
the cells individually I named ranges and then used ctrl+click to select them
when setting up the tab order. It typed it out for me. I still had to make
two tab orders due to the length. So now I ask you (since I've never used VBA
but did take BASIC (I won't mention how many years it has been) - how do I
get the worksheet open, while protected, and run the taborder1 then run
taborder2 without having to have them select it from the name range? I'm not
sure some of my computer illiterate company men will be able to do anything
but open it up, enter the data, save & print so I need it as automatic as
possible. THANK YOU AGAIN FOR SO MUCH HELP!!!
--
micah


"Gord Dibben" wrote:

See Bob Phillips' site for a couple of methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

The named range will probably suit but.........?

There is another method using sheet event code and Select Case to control Tab
order.

If interested post back.


Gord Dibben MS Excel MVP

On Mon, 29 Oct 2007 04:46:01 -0700, micah
wrote:

Sounds Great - better than any idea that I have been able to come up with or
research! If you can get me started I think I can add all of the in between
since there are so many, but here is the start of it:

d1, d2, d3, d4, d5, d, d7, d8, d9, j4 j5, c14, 15, c16, c17, c18, f14.......

Thanks for your help - I've been working on this all night and need to get
it done before 3 today if possible!