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

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

Check if text changed.
Heres an example. Normally people will fill out say, 40J, and then
40P. This means, of course, wasted time pressing the arrow keys to
move from 40J to 40P. What I want is to set it up so if they move out
of 40J, they instantly go to 40P. This is not hard to do-- I can do
it.
BUT.
If someone is just leisurely strolling through the worksheet and
happens to move through 40J without actually filling it out-- say, for
example, they are reviewing it before saving-- then it would be quite
BAD in that case to teleport them to 40P. quite annoying!
So, I would want to teleport them to 40P only *if* they actually
changed 40J.
Any help will be very much appreciated :-)

"Frank Kabel" wrote in message ...
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

A worksheet change event can do this for you. Try this:
Be sure to put it in the worksheet module.

'''''''''''''''''''''
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$J$40" Then
Range("$P$40").Select
End If
End Sub
''''''''''''''''''
hth
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"dreamvigile" wrote in message
om...
Check if text changed.
Heres an example. Normally people will fill out say, 40J, and then
40P. This means, of course, wasted time pressing the arrow keys to
move from 40J to 40P. What I want is to set it up so if they move out
of 40J, they instantly go to 40P. This is not hard to do-- I can do
it.
BUT.
If someone is just leisurely strolling through the worksheet and
happens to move through 40J without actually filling it out-- say, for
example, they are reviewing it before saving-- then it would be quite
BAD in that case to teleport them to 40P. quite annoying!
So, I would want to teleport them to 40P only *if* they actually
changed 40J.
Any help will be very much appreciated :-)

"Frank Kabel" wrote in message
...
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