topic Macro code to set textbox caption in QlikView

Macro code to set textbox caption

m_woolf — Fri, 23 Sep 2011 20:07:38 GMT

Can someone supply a code snippet that will set the caption to a textbox?

Thanks in acvance for your help.

Macro code to set textbox caption

kaushiknsolanki — Sat, 24 Sep 2011 05:29:22 GMT

HI,

This is the macro to set the caption for textbox.

set mybox = ActiveDocument.GetSheetObject("TX29") /// here TX29 is object ID for the textbox.

set mbp = mybox.GetProperties

mbp.Layout.Frame.Name.v = "abc"

mybox.SetProperties mbp

Regards,

Kaushik Solanki

Re: Macro code to set textbox caption

Wed, 24 Oct 2012 22:04:31 GMT

I'd like to set the caption of a chart like this, but unfortunately the code above doesn't work. It does work for a text box but if I put in the object ID for a chart with the same code it fails. Do you know why?