The current text of a cell while in edit mode.
Usage
Set_Property(OLECtrlEntID, "OLE.EditText", Text)
Values
Text can contain anything.
Default: ""
Remarks
The EditText property gets or sets the text of cell while it is in edit mode. If no cell is in edit mode, then this property has no effect.
Do not confuse this property with the CellText property as these two properties are not always the same. The CellText property is not updated until the user commits his/her changes by leaving the cell, whereas the EditText property is updated as the user types.
Use this property to updated what the user is typing without updating the cell's actual text. For instance, you could use this property to acheive auto-fill/auto-complete functionality.
Setting this property does not affect the Modified property, so be sure to set the Modified property to 1 if you want the changes to be committed.
Example
// Set the current edit content of the currently edit cell Set_Property(@Window:".OLE_EDITTABLE", "OLE.EditText", "Test") // Get the content of the currently edit cell CurrEditText = Set_Property(@Window:".OLE_EDITTABLE", "OLE.EditText")
