Arrays question

  • Thread starter Thread starter ×לי
  • Start date Start date
×

×לי

Hi!

I have 2 arrays. one array contains records from a table and the second
array contains only one record from the same table. The user may change one
or more values in the second array. My question is how can I test if the
second array was changed?

Thanks in advance

Eli
 
Hello Eli,

You can store your second array in a worksheet and check via the
Worksheet_Change event whether the Target parameter intersects with
your array cells.

Or you keep a copy of your second array in memory and whenever you
need to know whether its changed you apply an item-wise check.

Regards,
Bernd
 
Back
Top