Moving automatically by content to a new cell

  • Thread starter Thread starter oxymoron
  • Start date Start date
O

oxymoron

Hi all,

I would like to "tell" Excel when to move to a specific cell, by the
content of the cell I'm currently at.

fx. in A1 I know I allways want one (1) integer and then move to B1
where I want a a word with 4 letters, then move to A2 where I always
enter a two digit number and so on ...

How can I make this possible? I would like to avoid using arrows or
clicking the mouse. I think I should be able to "teach" Excel when a
certain criteria in one cell is present, and make it move to a given
new cell - but how?

TIA
 
From what you say, I gather that the cell addresses are relative. IOW, if
one digit is entered, move one cell to the right, and if 4 letters are
entered move one cell to the left and one cell down, etc.
One way would be to write a Worksheet_Change event macro. This macro
would execute automatically whenever a change is made to the contents of any
cell in the sheet. The code in the macro would look at the contents of the
changed cell and move the focus (select another cell) accordingly.
Post back if this sounds like something you want. Include more detail
about the cell content criteria. For instance, you say one cell may get 4
letters. I take that to mean that each character is a letter. This leads
to the question: Would you have any entries that have 4 characters where
only some of the characters are letters? Another question is what do you
want to happen if an entry is made that doesn't fit any of the criteria you
give? Also, do you want this to happen across the entire sheet or just in a
specified range on the sheet? HTH Otto
 
Back
Top