CellText
This property sets or returns the text of the table cell.
Syntax
CellText (Column as Variant, RowIndex as Long) as String
Parameter | Description |
---|---|
Column | Zero-based index or name of column |
RowIndex | Zero-based index of row |
Sample Code
Private Sub MyTableField_ValidateCell(pTable as SCBCdrPROJLib.SCBCdrTable, pWorkdoc as SCBCdrPROJLib.SCBCdrWorkdoc, ByVal Row as Long, ByVal Column as Long, pValid as Boolean)
Select Case Column
Case 0:
'check date in column 0
if CheckDate(pTable.CellText(Column, Row)) = FALSE then
pValid = FALSE
pTable. CellValidationErrorDescription(Column, Row) = "Invalid date"
end if
Case 2:
'check order number in column 2
if CheckOrderNumber(pTable.CellText(Column, Row)) = FALSE then
pValid = FALSE
pTable. CellValidationErrorDescription(Column, Row) = "Invalid order number"
end if
End Select
End Sub