Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrays question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrays question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
General Question About Arrays | Excel Programming | |||
question on arrays in vba | Excel Programming | |||
formula question for arrays | Excel Programming |