Hi
not quite sure what you're trying to achieve. Do you want code which
checks if you have entered 'Text' in a specific cell (and move the
cursor around). or do you want to check if 'Text' has been changed?

--
Regards
Frank Kabel
Frankfurt, Germany

"dreamvigile" schrieb im Newsbeitrag
om...
Hello,

In order to streamline the filling out of a certain worksheet, I
want to set it up so when you change a given cell and press enter or
any other command to leave it, you get whisked right into the next
cell you need to fill out, rather than having to move through a bunch
of "buffer" cells (cells you dont fill out, that just identify what
things are...)
I am able to check which cell they were previously in by putting a
"Dim prevcell As Range" at the top, setting this to Target as they
move around, and running if's on it to check what the previous cell
was when Worksheet_Changeselection is run.
I only want to whisk the activecell around if they actually CHANGED
text though-- dont want the thing to jump all over when theyre just
trying to manually move through with arrow keys...
The problem is, I can't get a similar strategy to work with a
"prevtext".
I do a Dim prevtext As String, then set it to target.formulaR1C1 as
they move around -- no luck. "Type mismatch". What would be the
proper method to do something of this nature?
Thanks very much in advance, very much appreciated.
SA