PDA

View Full Version : Change a variable without effecting other data rows



Aussiebear
05-18-2017, 03:16 AM
When entering a new row of data, by using a listbox variable as a major part of the determination, is it possible to stop the new selection from effecting the rows of data already entered ( as in recalculating the result) ?

mdmackillop
05-18-2017, 04:18 AM
Hi Ted
Not sure that I follow you, but you could set Calculation to xlManual prior to inserting a value. Is that what you need? Can you post an example?
Regards
Malcolm

Aussiebear
05-19-2017, 01:56 AM
The workbook I need to post is hiding offline some 300 klms away, so will work on another for posting shortly