[RESOLVED] Strange behavior with DataGrid BeforeColUpdate Event

[Hustey]

Hi,

I'm trying to run code as follows:

Private Sub DataGrid_BeforeColUpdate(ByVal ColIndex As Integer, OldValue As Variant, Cancel As Integer)
    Cancel = False
    DataGrid.Columns(ColIndex).Value = OldValue
End Sub

Taken from an example shown on the Microsoft site:
https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

For an unknown reason, it fails to write the OldValue to the cell being edited:





Maybe i'm being stupid, but I have no idea why it isn't working.

Thanks,

Hustey