View Single Post
  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.