Forum Discussion

FabrizioBBG's avatar
FabrizioBBG
Copper Contributor
Apr 13, 2023
Solved

change the color of the last character in a shape text of excel sheet in VBA

Good morning I would like to change the color of the last character in a shape text of excel sheet in VBA. The Shape is a button and the character on which to change the color is the check mark whic...
excel
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Apr 13, 2023

    FabrizioBBG 

    Change

    .Shapes.Range(Array(strNomeBottone)).TextFrame.Characters(Start:=Len(testoBottone) - 1, Length:=1).Font.Color = RGB(255, 0, 0)

    to

    .Shapes.Range(Array(strNomeBottone)).TextFrame.Characters(Start:=Len(testoBottone), Length:=1).Font.Color = vbRed
HansVogelaar's avatar
HansVogelaar
MVP
Apr 13, 2023

FabrizioBBG 

Change

.Shapes.Range(Array(strNomeBottone)).TextFrame.Characters(Start:=Len(testoBottone) - 1, Length:=1).Font.Color = RGB(255, 0, 0)

to

.Shapes.Range(Array(strNomeBottone)).TextFrame.Characters(Start:=Len(testoBottone), Length:=1).Font.Color = vbRed

Resources