topic Text Box Background Fill Colour Vba in QlikView https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212321#M503365 <HTML><HEAD></HEAD><BODY><H4>Hi all,</H4><H4>I am trying to use the following Macro to change the Background Colour of a Text Box. Can anyone suggest why it isn't working?</H4><H4>Sub fill</H4><H2>ActiveDocument.GetSheetObject("TX09").Select</H2><H2>Selection.Interior.Fill.Color = RGB(200,160,35)</H2><H2>End Sub</H2><H2></H2><H2>Help much appreciated!</H2><H4>Mbgm4mw3</H4></BODY></HTML> Tue, 13 Apr 2010 13:47:32 GMT 2010-04-13T13:47:32Z Text Box Background Fill Colour Vba https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212321#M503365 <HTML><HEAD></HEAD><BODY><H4>Hi all,</H4><H4>I am trying to use the following Macro to change the Background Colour of a Text Box. Can anyone suggest why it isn't working?</H4><H4>Sub fill</H4><H2>ActiveDocument.GetSheetObject("TX09").Select</H2><H2>Selection.Interior.Fill.Color = RGB(200,160,35)</H2><H2>End Sub</H2><H2></H2><H2>Help much appreciated!</H2><H4>Mbgm4mw3</H4></BODY></HTML> Tue, 13 Apr 2010 13:47:32 GMT https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212321#M503365 2010-04-13T13:47:32Z Text Box Background Fill Colour Vba https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212322#M503367 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>It could be because there is no such VBA function RGB.</P><P>Try this instead ActiveDocument.EVALUATE("RGB(10, 20, 30)")</P><P>Cheers</P><P>Darius</P></BODY></HTML> Tue, 13 Apr 2010 13:57:17 GMT https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212322#M503367 d_pranskus 2010-04-13T13:57:17Z Text Box Background Fill Colour Vba https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212323#M503368 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>you can use the following macro</P><P></P><P></P><P>sub fill</P><P></P><P>set mybox=activedocument.getsheetobject("TX01")</P><P>mbp= mybox.getproperties</P><P>mbp.layout.bkgcolor.primarycol.col=rgb(200,160,35)</P><P>mybox.setproperties mbp</P><P>end sub</P><BR /><BR /> <P></P><P>thanks</P><P></P><P></P></BODY></HTML> Wed, 14 Apr 2010 05:41:31 GMT https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212323#M503368 2010-04-14T05:41:31Z Text Box Background Fill Colour Vba https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212324#M503369 <HTML><HEAD></HEAD><BODY><P>Thanks Tauqueer that's absolutely brilliant!</P><P>Do you know the QV syntax if I want to change the fill color of a shape placed in a text box as an "image" rather than changing bkgcolor?</P><P>Mbgm4mw3</P></BODY></HTML> Wed, 14 Apr 2010 09:32:11 GMT https://community.qlik.com/t5/QlikView/Text-Box-Background-Fill-Colour-Vba/m-p/212324#M503369 2010-04-14T09:32:11Z