I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cells between column F and M are calculated cells and do not need to
be selected. The cell in column A has the date automatically calculated
when data is added to cell B, C or D.
Please make your reply simple for me to follow as I am rather ignorant
as far as VB is concerned.

Orf

This takes a few steps to get to work exactly the way you want it to.

First, the coding part. Enter this into the Workbook code section using the
Visual Basic Editor

Option Explicit

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("B65536").End(xlUp).Offset(1, 0).Select
End Sub

To get into the VB Editor, start by pressing [Alt]+[F11] then look at the
Project window and double-click the entry in the 'tree' that says "This
Workbook". If you don't see the Project window (left side of the screen,
upper left 1/3rd of the screen) choose View | Project from the menu bar.

This presumes that the first empty cell in column B will be at the end of a
list of entries in that column, and that there are not empty cells within
filled in cells in that column. If the sheet name you need to go to is
something other than "Sheet1", change that, of course.

To get your cursor to move from Left to Right across the sheet instead of
top to bottom, go to
Toos | Options and choose the [Edit] tab. Find the entry that says "Move
Selection After Enter" and check the box next to it and change the direction
from "Down" to "Right"

Now that doesn't stop the cursor from stopping in cells in between the
columns you want it to stop at. Here's how to "fix" that:

Choose the columns where you do want the user to enter information into and
then use Format | Cells and uncheck the box next to "Locked" on the
[Protection] tab. You will want to do this for all columns that you want the
user to be able to enter information into, as B, C, D, E, F, M, N and O. Go
back to your worksheet and choose
Tools | Protection | Protect Sheet
and clear the checkbox next to the entry that says Select Locked Cells.
Whether or not you assign a password as being required to unlock the sheet is
up to you. Until you test it and make sure it works, I'd just leave it blank
that way all you have to do is choose Tools | Protection | Unprotect Sheet to
work in it some more.

This should set you up to work the way you want it all to work.

"Orf Bartrop" wrote:

I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cells between column F and M are calculated cells and do not need to
be selected. The cell in column A has the date automatically calculated
when data is added to cell B, C or D.
Please make your reply simple for me to follow as I am rather ignorant
as far as VB is concerned.

Orf

Thank you, I will try this later today.

JLatham wrote:

This takes a few steps to get to work exactly the way you want it to.

First, the coding part. Enter this into the Workbook code section using the
Visual Basic Editor

Option Explicit

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("B65536").End(xlUp).Offset(1, 0).Select
End Sub

To get into the VB Editor, start by pressing [Alt]+[F11] then look at the
Project window and double-click the entry in the 'tree' that says "This
Workbook". If you don't see the Project window (left side of the screen,
upper left 1/3rd of the screen) choose View | Project from the menu bar.

This presumes that the first empty cell in column B will be at the end of a
list of entries in that column, and that there are not empty cells within
filled in cells in that column. If the sheet name you need to go to is
something other than "Sheet1", change that, of course.

To get your cursor to move from Left to Right across the sheet instead of
top to bottom, go to
Toos | Options and choose the [Edit] tab. Find the entry that says "Move
Selection After Enter" and check the box next to it and change the direction
from "Down" to "Right"

Now that doesn't stop the cursor from stopping in cells in between the
columns you want it to stop at. Here's how to "fix" that:

Choose the columns where you do want the user to enter information into and
then use Format | Cells and uncheck the box next to "Locked" on the
[Protection] tab. You will want to do this for all columns that you want the
user to be able to enter information into, as B, C, D, E, F, M, N and O. Go
back to your worksheet and choose
Tools | Protection | Protect Sheet
and clear the checkbox next to the entry that says Select Locked Cells.
Whether or not you assign a password as being required to unlock the sheet is
up to you. Until you test it and make sure it works, I'd just leave it blank
that way all you have to do is choose Tools | Protection | Unprotect Sheet to
work in it some more.

This should set you up to work the way you want it all to work.

"Orf Bartrop" wrote:



I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cells between column F and M are calculated cells and do not need to
be selected. The cell in column A has the date automatically calculated
when data is added to cell B, C or D.
Please make your reply simple for me to follow as I am rather ignorant
as far as VB is concerned.

Orf

I believe all of that should take you to the point you've asked for. If you
have any difficulty with inserting the code or finding your way around in the
VB Editor, hopefully the information I've provided on this page will help:
http://www.jlathamsite.com/Teach/WorkbookCode.htm


"Orf Bartrop" wrote:

Thank you, I will try this later today.

JLatham wrote:

This takes a few steps to get to work exactly the way you want it to.

First, the coding part. Enter this into the Workbook code section using the
Visual Basic Editor

Option Explicit

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("B65536").End(xlUp).Offset(1, 0).Select
End Sub

To get into the VB Editor, start by pressing [Alt]+[F11] then look at the
Project window and double-click the entry in the 'tree' that says "This
Workbook". If you don't see the Project window (left side of the screen,
upper left 1/3rd of the screen) choose View | Project from the menu bar.

This presumes that the first empty cell in column B will be at the end of a
list of entries in that column, and that there are not empty cells within
filled in cells in that column. If the sheet name you need to go to is
something other than "Sheet1", change that, of course.

To get your cursor to move from Left to Right across the sheet instead of
top to bottom, go to
Toos | Options and choose the [Edit] tab. Find the entry that says "Move
Selection After Enter" and check the box next to it and change the direction
from "Down" to "Right"

Now that doesn't stop the cursor from stopping in cells in between the
columns you want it to stop at. Here's how to "fix" that:

Choose the columns where you do want the user to enter information into and
then use Format | Cells and uncheck the box next to "Locked" on the
[Protection] tab. You will want to do this for all columns that you want the
user to be able to enter information into, as B, C, D, E, F, M, N and O. Go
back to your worksheet and choose
Tools | Protection | Protect Sheet
and clear the checkbox next to the entry that says Select Locked Cells.
Whether or not you assign a password as being required to unlock the sheet is
up to you. Until you test it and make sure it works, I'd just leave it blank
that way all you have to do is choose Tools | Protection | Unprotect Sheet to
work in it some more.

This should set you up to work the way you want it all to work.

"Orf Bartrop" wrote:



I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cells between column F and M are calculated cells and do not need to
be selected. The cell in column A has the date automatically calculated
when data is added to cell B, C or D.
Please make your reply simple for me to follow as I am rather ignorant
as far as VB is concerned.

Orf

Works fine thank you.

Orf

JLatham wrote:

This takes a few steps to get to work exactly the way you want it to.

First, the coding part. Enter this into the Workbook code section using the
Visual Basic Editor

Option Explicit

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("B65536").End(xlUp).Offset(1, 0).Select
End Sub

To get into the VB Editor, start by pressing [Alt]+[F11] then look at the
Project window and double-click the entry in the 'tree' that says "This
Workbook". If you don't see the Project window (left side of the screen,
upper left 1/3rd of the screen) choose View | Project from the menu bar.

This presumes that the first empty cell in column B will be at the end of a
list of entries in that column, and that there are not empty cells within
filled in cells in that column. If the sheet name you need to go to is
something other than "Sheet1", change that, of course.

To get your cursor to move from Left to Right across the sheet instead of
top to bottom, go to
Toos | Options and choose the [Edit] tab. Find the entry that says "Move
Selection After Enter" and check the box next to it and change the direction
from "Down" to "Right"

Now that doesn't stop the cursor from stopping in cells in between the
columns you want it to stop at. Here's how to "fix" that:

Choose the columns where you do want the user to enter information into and
then use Format | Cells and uncheck the box next to "Locked" on the
[Protection] tab. You will want to do this for all columns that you want the
user to be able to enter information into, as B, C, D, E, F, M, N and O. Go
back to your worksheet and choose
Tools | Protection | Protect Sheet
and clear the checkbox next to the entry that says Select Locked Cells.
Whether or not you assign a password as being required to unlock the sheet is
up to you. Until you test it and make sure it works, I'd just leave it blank
that way all you have to do is choose Tools | Protection | Unprotect Sheet to
work in it some more.