I've got a daily process VBA code that runs several commands, queries, and macros every morning. I'd like to have a form that pops up when it runs to show the status of the process. This is important for me to show if it doesnt complete, that the user would be able to see the last process completed. It needs to dynamically change from Complete to Not Complete as each task is completed of course. The form layout would produce something similar to what i'll show below:
Daily Process:
Task 1: Complete
Task 2: Complete
Task 3: Not Complete!
The form could draw the Complete/Not complete from a table which is updated via VBA when process are executed.
My problem is this:
1. I'm not sure how to go about displaying the table data in the form without doing a list box.
2. I dont know how to update the form once a value in the complete/not complete table is updated. (i tried playing around with me.repaint but never could get it to work)
Thanks in advance for any help
G
Daily Process:
Task 1: Complete
Task 2: Complete
Task 3: Not Complete!
The form could draw the Complete/Not complete from a table which is updated via VBA when process are executed.
My problem is this:
1. I'm not sure how to go about displaying the table data in the form without doing a list box.
2. I dont know how to update the form once a value in the complete/not complete table is updated. (i tried playing around with me.repaint but never could get it to work)
Thanks in advance for any help
G
Last edited:
