Community
Inventor Programming - iLogic, Macros, AddIns & Apprentice
Inventor iLogic, Macros, AddIns & Apprentice Forum. Share your knowledge, ask questions, and explore popular Inventor topics related to programming, creating add-ins, macros, working with the API or creating iLogic tools.
cancel
Showing results forĀ 
ShowĀ Ā onlyĀ  | Search instead forĀ 
Did you mean:Ā 

iLogic to tick Excel Tick box

2 REPLIES 2
SOLVED
Reply
Message 1 of 3
youann21700
167 Views, 2 Replies

iLogic to tick Excel Tick box

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?

2 REPLIES 2
Message 3 of 3
A.Acheson
in reply to: youann21700

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.

 

If this solved a problem, please click (accept) as solution.ā€Œā€Œā€Œā€Œ
Or if this helped you, please, click (like)ā€Œā€Œ
Regards
Alan

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Technology Administrators


Autodesk Design & Make Report