Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i'm new with qlikview and i need to resize a textbox object containig an image when i activate it.
I need also to move the textbox to the centre of the sheet.
Can someone help me?
Thanks alot
Andrea from Italy
Hi
Can you give us a little explanation to why you want to do this because I have a feeling that there might be alternative ways to go here...
/Fredrik
I show in a textbox a small image cause i've many chart inside the sheet so te textbox is small.
I want the user to click (or activate) the text box and then it will be resized and moved to the centre of the sheet to see better the detail on the picture.
Hope it's clear enough.
Bye
Andrea
i've solved the problem
attacched the solution.
sub move_to_new_pos
dim tbl
dim tblrect
set tbl = Application.ActiveDocument.GetSheetObject("TX01")
set tblrect = tbl.GetRect
tblrect.Left = 100
tblrect.Top = 100
tblrect.Height = 480
tblrect.Width = 576
tbl.SetRect(tblrect)
end sub
sub move_to_old_pos
dim tbl
dim tblrect
set tbl = Application.ActiveDocument.GetSheetObject("TX01")
set tblrect = tbl.GetRect
tblrect.Left = 1490
tblrect.Top = 4
tblrect.Height = 48
tblrect.Width = 48
tbl.SetRect(tblrect)
end sub
Came here looking for the solution to just resizing textobject and you gave it to me. Thanks!