Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
you can use the following macro
sub fill
set mybox=activedocument.getsheetobject("TX01")
mbp= mybox.getproperties
mbp.layout.bkgcolor.primarycol.col=rgb(200,160,35)
mybox.setproperties mbp
end sub
thanks
Hi
It could be because there is no such VBA function RGB.
Try this instead ActiveDocument.EVALUATE("RGB(10, 20, 30)")
Cheers
Darius
hi,
you can use the following macro
sub fill
set mybox=activedocument.getsheetobject("TX01")
mbp= mybox.getproperties
mbp.layout.bkgcolor.primarycol.col=rgb(200,160,35)
mybox.setproperties mbp
end sub
thanks
Thanks Tauqueer that's absolutely brilliant!
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?
Mbgm4mw3