Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change Font Color

hi,

guys

i want to change the font color of text object using macro

thanks in advance

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Nishit,

Try this,

Sub Test

set mytext = ActiveDocument.GetSheetObject("TX01")

prop = mytext.GetProperties

prop.Layout.TextColor.PrimaryCol.Col = RGB(255,255,50)

mytext.SetProperties prop

End sub

View solution in original post

2 Replies
effinty2112
Master
Master

Hi Nishit,

               As an alternative to using a macro consider controlling the font colour with a variable. You can set the value of the variable using triggers.

Cheers

Andrew

tamilarasu
Champion
Champion

Nishit,

Try this,

Sub Test

set mytext = ActiveDocument.GetSheetObject("TX01")

prop = mytext.GetProperties

prop.Layout.TextColor.PrimaryCol.Col = RGB(255,255,50)

mytext.SetProperties prop

End sub