Changing AcxTable cell values

[TonyBarker]

I am trying to changes values in an AcxTable cell using the SetCellData command, however although the value changes on the screen it is not stored in a calculation, ie when accpeting this change, the new value is ignored so when the screen is re-visited the original value is displayed. I have used the following command to change a value :-

Code:

'VbWindow("frmFinancialOverviewEdit").AcxTable("MSFlexGrid").SetCellData 7, 4, DataTable("VehicleDamage", dtGlobalSheet)

is there anything else i need to code ?