Forum Discussion
Solved
How to add checkboxes and timestamps to my table in Power Query/Excel?
Hello, I know Power Query does not offer the ability to direcctly add Form Controls, but is there another work around to add in checkboxes? I wrote a query to pull orders for each day. The user ...
Hi dolphin18 You could do this by combining Power Query and VBA. Use Power Query to generate the table and VBA to add checkboxes in the "Received?" column. Write a macro to insert checkboxes for each row and another to record timestamps when checkboxes are checked. After refreshing the table in Power Query, re-run the VBA macro to realign the checkboxes.
Akash_Varuna
Super User
Super Userdolphin18 you can modify the VBA macro to include a condition that clears the timestamp cell if the checkbox is unchecked
Thank you! I added a condition and it is working now!