I want to trigger an event when the row is changed as opposed to a cell. How
would I do this?

i.e.

I'm on row 12. I make a change to the B column, then tab to the C column.
After entering data in C, I tab over to F and enter more data. I don't want
the event to trigger until I click another row or hit the Enter key.

Hi
you would us ealso the worksheet_change event and check if anything
within your row is changed.

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag ...
I want to trigger an event when the row is changed as opposed to a
cell. How
would I do this?

i.e.

I'm on row 12. I make a change to the B column, then tab to the C
column.
After entering data in C, I tab over to F and enter more data. I
don't want
the event to trigger until I click another row or hit the Enter key.

I've already got a worksheet_change event in my code. How would I check if
the row has changed since the last entry?

"Frank Kabel" wrote:

Hi
you would use also the worksheet_change event and check if anything
within your row is changed.

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag ...
I want to trigger an event when the row is changed as opposed to a
cell. How
would I do this?

i.e.

I'm on row 12. I make a change to the B column, then tab to the C
column.
After entering data in C, I tab over to F and enter more data. I
don't want
the event to trigger until I click another row or hit the Enter key.

Hi
you could check with
if not intersect(target,me.range("1:1")) is nothing then
msgbox "change in row 1"
end if

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag ...
I've already got a worksheet_change event in my code. How would I
check if
the row has changed since the last entry?

"Frank Kabel" wrote:

Hi
you would use also the worksheet_change event and check if anything
within your row is changed.

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag
...
I want to trigger an event when the row is changed as opposed to
a
cell. How
would I do this?

i.e.

I'm on row 12. I make a change to the B column, then tab to the
C
column.
After entering data in C, I tab over to F and enter more data. I
don't want
the event to trigger until I click another row or hit the Enter
key.

That statement triggers only when in row 1 and regardless of whether I change
rows.

I need something that will trigger ONLY when I change rows.

For example.

Enter data at A1, tab (no event triggered), enter data at B1, tab(no event
triggered), enter data at C1, enter (event triggers here)
"Frank Kabel" wrote:

Hi
you could check with
if not intersect(target,me.range("1:1")) is nothing then
msgbox "change in row 1"
end if

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag ...
I've already got a worksheet_change event in my code. How would I
check if
the row has changed since the last entry?

"Frank Kabel" wrote:

Hi
you would use also the worksheet_change event and check if anything
within your row is changed.

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag
...
I want to trigger an event when the row is changed as opposed to
a
cell. How
would I do this?

i.e.

I'm on row 12. I make a change to the B column, then tab to the
C
column.
After entering data in C, I tab over to F and enter more data. I
don't want
the event to trigger until I click another row or hit the Enter
key.

Hi
so you may explain what you mean with 'then I change rows'

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag ...
That statement triggers only when in row 1 and regardless of whether
I change
rows.

I need something that will trigger ONLY when I change rows.

For example.

Enter data at A1, tab (no event triggered), enter data at B1, tab(no
event
triggered), enter data at C1, enter (event triggers here)
"Frank Kabel" wrote:

Hi
you could check with
if not intersect(target,me.range("1:1")) is nothing then
msgbox "change in row 1"
end if

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag
...
I've already got a worksheet_change event in my code. How would
I
check if
the row has changed since the last entry?

"Frank Kabel" wrote:

Hi
you would use also the worksheet_change event and check if
anything
within your row is changed.

--
Regards
Frank Kabel
Frankfurt, Germany

"crazybass2" schrieb im
Newsbeitrag
...
I want to trigger an event when the row is changed as opposed
to
a
cell. How
would I do this?

i.e.

I'm on row 12. I make a change to the B column, then tab to
the
C
column.
After entering data in C, I tab over to F and enter more
data. I
don't want
the event to trigger until I click another row or hit the
Enter
key.