Excel 2003- Tabbing to a specific location in a cell

[monty the magician]

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

 

[Gary Keramidas]

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

 

[L. Howard Kittle]

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

 

[Dave Peterson]

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.

 

[Dave Peterson]

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.

 

[Bob I]

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

 

[L. Howard Kittle]

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