cell value indeterminate while editing

[Andy]

I am using IDTExtensibility2 with VB6 to produce a COM addin for Excel
2002 (so
no VBA code inside Excel). I add a button dynamically in my VB6 code

e.g. Private WithEvents cmdMyButton_ As Office.CommandBarButton

The problem when a user is editing a cell & clicks on a
CommandBarButton,
there is no way of getting the TRUE cell value
(ws.Cells(row,col).text), only
the previously stored one. e.g. if the user changes the cell value
from 30 to 50 and stays in edit mode, ws.Cells(row,col).text will give
30 !

Also, any way of determining the event between the user leaving the
cell "edit mode" and clicking the button ?