Excel 2003- Tabbing to a specific location in a cell
 

I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a specific
area in the cell...how do i set up my template to do this?
THanks so much

Excel 2003- Tabbing to a specific location in a cell
 

unlock the cells you want to tab to. leave the other cells protected. then
protected the sheet.

--


Gary Keramidas
Excel 2003


"monty the magician" <monty the wrote in
message ...
I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a
specific
area in the cell...how do i set up my template to do this?
THanks so much

Excel 2003- Tabbing to a specific location in a cell
 

One way is to name the specific cells you want to enter the data into.
Select the second cell of the bunch of cells of a group and hold down Shift
and click on each cell in the sequence you want to enter the data, ending
with the first cell. Now, while the first cell is still selected, name the
range of selected cells with an appropriate name given the data to be
entered. For example, Costs, Expenses, Supplies, etc.

Select a name from the name box from the Name Box and see the cells of the
named range are highlighted. Enter the data in the first cell and hit
either Enter or Tab and continue through the range until back to cell 1.
Left or right arrow out of the named range. (Up or Down also)

So now if someone hands you a list of Expenses to enter, you select Expenses
from the Name Box and enter the data. Same with the other named ranges.

If you go with sheet protection method that may work well for you if you
always have the same sequence of data to enter in the unprotected cells and
the data is in that sequence also.

HTH
Regards,
Howard

"monty the magician" <monty the wrote in
message ...
I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a
specific
area in the cell...how do i set up my template to do this?
THanks so much

Excel 2003- Tabbing to a specific location in a cell
 

If you really mean that you want to tab to a location within a cell, then I
think you're out of luck. I've never seen a macro that does anything
significant run while you're editing the cell.



monty the magician wrote:

I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a specific
area in the cell...how do i set up my template to do this?
THanks so much

--

Dave Peterson

Excel 2003- Tabbing to a specific location in a cell
 

ps. On the other hand, maybe you could build an interface (a userform) that
gets the data from the user. You may be able to set that insertion point where
you want it.



monty the magician wrote:

I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a specific
area in the cell...how do i set up my template to do this?
THanks so much

--

Dave Peterson

Excel 2003- Tabbing to a specific location in a cell
 

Why does it need to be in a specific character position within a cell?

monty the magician wrote:

I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a specific
area in the cell...how do i set up my template to do this?
THanks so much

Excel 2003- Tabbing to a specific location in a cell
 

I missed the part where you want to be at a certain location in the cell.
You might try something like this and modify to suit the location within the
cell. This gives you three spaces and an X, then a carriage return and then
two spaces and a y. The x and y are just to show the location within the
cell. Delete them for just spaces.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveCell.FormulaR1C1 = " X" & Chr(10) & " y"
End Sub

Use this along with the named ranges i mentioned in my previous post.

HTH
Regards,
Howard

"L. Howard Kittle" wrote in message
...
One way is to name the specific cells you want to enter the data into.
Select the second cell of the bunch of cells of a group and hold down
Shift and click on each cell in the sequence you want to enter the data,
ending with the first cell. Now, while the first cell is still selected,
name the range of selected cells with an appropriate name given the data
to be entered. For example, Costs, Expenses, Supplies, etc.

Select a name from the name box from the Name Box and see the cells of the
named range are highlighted. Enter the data in the first cell and hit
either Enter or Tab and continue through the range until back to cell 1.
Left or right arrow out of the named range. (Up or Down also)

So now if someone hands you a list of Expenses to enter, you select
Expenses from the Name Box and enter the data. Same with the other named
ranges.

If you go with sheet protection method that may work well for you if you
always have the same sequence of data to enter in the unprotected cells
and the data is in that sequence also.

HTH
Regards,
Howard

"monty the magician" <monty the wrote
in message ...
I have created a template and I want to be able to fill in parts of the
template
by just tabbing and the cursor to move to the next cell...and to a
specific
area in the cell...how do i set up my template to do this?
THanks so much