Font colour in cell table

SupportCommunity Automation and VBA Font colour in cell table

15 sujets de 1 à 15 (sur un total de 22)
  • Auteur
    Messages
  • #12833
    HerveM1234HerveM1234
    Participant

    Hi,

    Is it possible to modify the font colour in a cell table depending of the value to display ?
    For example, values calculated above 100 in red and below 100 in green.
    Thanks for your help.

    #8492
    HerveM1234HerveM1234
    Participant

    Hi,

    Is it possible to modify the font colour in a cell table depending of the value to display ?
    For example, values calculated above 100 in red and below 100 in green.
    Thanks for your help.

    #9309
    Bernhard KantzBernhard Kantz
    Modérateur/modératrice

    The only way to modify the font color of a cell table is to use VBA (in FlexPro Professional). You can check if the value is out of limit and then change the color. Here is an example how to change the font properties of cell nr 3:

    Dim myTable As CellTable
    Set myTable = ActiveDatabase.ActiveFolder.Object("CellTable", fpObjectTypeCellTable)
    Dim myCell As CellTableCell
    Set myCell = myTable.Cells(3)
    With myCell.Text.Font
    	.Italic = False
    	.Name = "Arial"
    	.Size = 12
    	.Color = &H8000000F
    End With
    #9310
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9311
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9312
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9313
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9314
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9315
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9316
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9317
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9318
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9319
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9320
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

    #9321
    HerveM1234HerveM1234
    Participant

    Hi,

    Thanks for your reply.
    The font setting works very well

    The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
    How in VBA can I compare this “value” to an integer or an string for example ?

    Thanks again

15 sujets de 1 à 15 (sur un total de 22)
  • Vous devez être connecté pour répondre à ce sujet.