Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Testing the content of a table cell

The following example sets the focus to cell on 11th row and 11th column of the table if the value of this cell is less than 20.

Let's have the PmiAx graphic item in the oAx variable placed in the image editor (this graphic item is set to the PmTable ActiveX object).

Example:
Dim TextOfCell, oAxTable
Set oAxTable = oAx.Acx
oAxTable.FocusedCol = 11
oAxTable.FocusedRow = 11
TextOfCell = oAxTable.FocusedCellText
If CInt(TextOfCell) < 20 Then
  oAxTable.RowForeColor = "#ff0000" 'color setting by RGB String
End If
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice