topic How to change a button-caption by vb-script? in QlikView

How to change a button-caption by vb-script?

Wed, 08 Feb 2012 10:50:21 GMT

Hi all!

It is possible to change a button-caption with a vb-script?

My button:

set Obj = ActiveDocument.GetSheetObject("CH01")

Thanks

Daniel

How to change a button-caption by vb-script?

jagan — Wed, 08 Feb 2012 10:54:45 GMT

Hi,

Can you explain when the button caption should be changed.

You can use variable or dynamic expression to assign caption for the button instead going for macro.

Regards,

Jagan.

How to change a button-caption by vb-script?

Wed, 08 Feb 2012 11:50:33 GMT

Hi Jagan,

the button starts a vb-macro which will take nearly a minute.

The button-caption should change to "Please wait..." while the macro runs (at the beginning) to give a signal to the user that qlikview is working. The last command in the macro should turn the caption back.

Regards

Daniel

How to change a button-caption by vb-script?

jagan — Wed, 08 Feb 2012 12:17:28 GMT

Hi Daniel,

Add two more actions to the button. One before the macro and the other after the macro. In the first action change the value of a variable to "Please wait..." and in the last action change the value of the variable to original caption. Now use this variable value as caption to the button.

Hope this helps you.

Regards,

Jagan.

How to change a button-caption by vb-script?

Wed, 08 Feb 2012 14:10:23 GMT

Hello again,

thanks for your help.

The problem is that die second action (macro) starts bevor the changing of the variable-value can take effect. So in the end the button-caption is always the same.

Here same screenshots (Language=German):

Regards

Daniel