Forum Discussion
How to add checkboxes and timestamps to my table in Power Query/Excel?
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.
Super UserHi 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.
Hi Akash_Varuna, thank you for the suggestion! I was able to do as you said and got both to work together. However, when I uncheck a box, the timestamp will stay in the column next to the checkbox. Do you know how the timestamp can be removed when I uncheck a box?
- Akash_Varuna
dolphin18 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!
