topic Re: Border Color in QlikView

Border Color

Wed, 25 Nov 2020 16:16:04 GMT

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

Thnx in advance

vcanale — Mon, 04 Jul 2016 11:28:51 GMT

rubenmarin — Mon, 04 Jul 2016 11:34:41 GMT

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 — Mon, 04 Jul 2016 11:46:05 GMT

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

- Marcus

Peter_Cammaert — Mon, 04 Jul 2016 12:03:02 GMT

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