I have a listbox that I want to be able to edit the cell ( actually figured that out )… but I also want the new value of that cell to be used in a calculation for corrective purposes.
So in more clear terms. I select a cell, change that cells value ( I can do this already ) then when I leave the cell or finish with my change I want that new value to be used to recalculate another field outside of the listbox. This I have not been able to figure out. I have looked at the documentation and it covers how to edit but not how to get the value out for use.
This listbox is not connected to a table or database but is an on the fly creation. It’s sole function is to merely display values as I enter them. Sometimes I get the value incorrect so I need to change it. Hence why I want to use the new value for recalculating an existing value.