Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
somenathroy
Creator III
Creator III

How to change content of a cell by macro

Hi All,

Can anyone help me out to change the content of a cell of a Straight Table by specifying it's row, column index using macro.

Thanks,

Som

3 Replies
erichshiino
Partner - Master
Partner - Master

Hi,

This is only possible if you are working with inputfields, then the code will be like this

(I got it from the API Guide)

set obj = ActiveDocument.GetSheetObject("TB01")

obj.SetInputFieldCell 1,1,"999"   'set 2nd row value in 2nd column to 999

Hope it helps,

Erich

Not applicable

And what if it is a straight table? Isnt it possible to change values in cells? cos that doesnt seem to be very complicated...

Thanks.

Not applicable

Hi dude, I tried your code but it is not working.

Other question, do you know if it is possible to change the color of the cell in a Table Box with a macro?

Thanks for your help