What's not working? CellChange is the correct event. But you must use the Text property of the cell in this event. You cannot use Value, because Value will not be updated until the focus leaves the cell.