iLogic to tick Excel Tick box

[youann21700]

I am using a form to complete an excel sheet. Currently I am using True/False labels in certain boxes, ideally I would use tick boxes. Is it possible to get iLogic to operate excel tick boxes?

[Stakin]

maybe you can  start from:

https://knowledge.autodesk.com/support/inventor/learn-explore/caas/simplecontent/content/create-wind...

https://forums.autodesk.com/t5/inventor-programming-ilogic/create-form-with-ilogic/m-p/12435474

https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-create-a-check-box-list/m-p/113931...

https://forums.autodesk.com/t5/inventor-programming-ilogic/creating-a-quot-preview-window-quot-in-a-...

[A.Acheson · Accepted solution]

Hi @youann21700 

Here is a VBA method to read/write to excel cell checkbox.  Assuming this is what you have a checkbox for manual operation on an excel sheet and you want to programically change?

Are you starting from a local I logic form? If so you can just use the parameters true false status to trigger a rule.N the rule you need to open excel, find the check box cell and change the checkbox status.