topic Change Font Color in QlikView

Change Font Color

Mon, 04 Jul 2016 07:57:05 GMT

hi,

guys

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

thanks in advance

effinty2112 — Mon, 04 Jul 2016 08:07:55 GMT

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 — Mon, 04 Jul 2016 08:14:09 GMT

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