Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Increase/Decrease the size of text object through macro

Hello,

I want to increase or decrease the size of text object through the macro code.

How can i get the width & hight values of text object?

How to change those values ?

1 Solution

Accepted Solutions
Not applicable
Author

hi,

use this

sub cin

set obj = ActiveDocument.GetSheetObject("TX01")

    set fr = obj.GetFrameDef

    set pos = fr.Rect

    pos.Width = pos.Width * 1.1

    pos.Height = pos.height * 1.1

    obj.SetFrame fr,true,dummy

      End sub

to increase......multiply with .9 to decres size,,

here is the attached sample app....

Enjoy...!!!!!!

Regards

Arun

...

View solution in original post

4 Replies
Not applicable
Author

hi,

use this

sub cin

set obj = ActiveDocument.GetSheetObject("TX01")

    set fr = obj.GetFrameDef

    set pos = fr.Rect

    pos.Width = pos.Width * 1.1

    pos.Height = pos.height * 1.1

    obj.SetFrame fr,true,dummy

      End sub

to increase......multiply with .9 to decres size,,

here is the attached sample app....

Enjoy...!!!!!!

Regards

Arun

...

Not applicable
Author

Thanks goel..

Not applicable
Author

Hi goel,

this is working well with the IE plugin ... if i convert this into webview.. the macro is not working .. any solution for this ...please

thanks in advance ...

Regards,

Ramakanth

Not applicable
Author

hi,

Macro do not run in web view or through access point.....only inbuilt actions can be performed in such cases.....

You can do this through variables, using show hide text boxes ......

Regards

Arun Goel