Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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