Border Color

[#1]

hi

I want to give  a text object a border color using macro

Thnx in advance

[vcanale]

Hi,
Try if you can adapt this solution to your case:
How to get access to Chart border properties using macro

[rubenmarin]

Hi Nishit, this sub changes the border color of the text object 'TX01' to green when the macro is executed:

Sub bordercolor

set mybox = ActiveDocument.GetSheetObject("TX01")

mbp = mybox.GetProperties

mbp.Layout.Frame.BorderEffect = 3

mbp.Layout.Frame.Color.PrimaryCol.Col = RGB(0,255,0)

mbp.Layout.Frame.BorderWidth = 5

mybox.SetProperties mbp

end sub

Adpated from the example of the automation help, not sure if this is the last automation help document for macros: QlikView Core COM API Guide - Version 11

[marcus_sommer]

Why do you want a macro for this? A border-color could be an expression and therefore react on different conditions.

- Marcus

[Peter_Cammaert]

Please don't post the same question multiple times, even if you change forums: border color Thanks.