Excel 2003- Tabbing to a specific location in a cell

  • Thread starter monty the magician
  • Start date
M

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
 
G

Gary Keramidas

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

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
 
D

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.
 
D

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.
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top