Forum Discussion
macro trouble: wait, msgbox and manual calc
how do you trigger the macro? did you use an "on change" event on the page where you want the macro run?
No I did not use " change" but i just tried that and fixed problem. Thank you.
I did not get the desired result though. I wanted to edit the spreadsheet while the timer was running. Instead however the spreadsheet hour glasses (preventing additional edit) then reverts to manual calc. I dont want manual calc mode until i finish editing. It would also be nice to see the timer countdown. Any advice?I do not know why you need to stop calculation until finishind editing.
However you can try to create a user form for data entry for the data you need. Than after "OK" button pressed you can write those values to the required cells. This would be the easiest solution. You can also force this user form to be shown whenever the workbook opens or someone try to change the cells where user is only allowed by this user form.
If you want to display time passed only, you can try to load a user form in non modal state to show the timer however it will be sent back whenever Excel is activated. I do not know if it is possible to keep it on top while active, never needed that functionality.
