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