Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with a Macro

Dear All,

Please help me understand the meaning of this macro statements:

Sub(move)

set ListBox = ActiveDocument.GetSheetObject("CH15")

Set cell = listBox.GetCell(2,9)

ActiveDocument.Variables("tutan").SetContent cell.text, true

CH15 object is a straight table.

Set cell = listBox.GetCell(3,9)

ActiveDocument.Variables("manka").SetContent cell.text, true

Thanks,

Tutan

1 Solution

Accepted Solutions
Not applicable
Author

it's assigning the value at row 2 column 9 from your table "CH15" to the variable tutan.

View solution in original post

3 Replies
Not applicable
Author

it's assigning the value at row 2 column 9 from your table "CH15" to the variable tutan.

Not applicable
Author

Instead of using a Macro, how can I pass values to the variable tutan from row 2 column 9 from the table CH15? Is there a way I can code this in the load script? So that , I dont need a macro to run when a button is pressed. Instead, this the variable tutan is automatically loaded once we hit reload.

Thanks,

Tutan

Not applicable
Author

I'd need to know what is being displayed in that cell. could you upload an example of your QVW?