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 ?