Brian.Crawford
Board Regular
- Joined
- Oct 3, 2007
- Messages
- 136
I have a form generated in VBA that at the end of some processing disappears from the screen but is still active. Sometimes i can get it back simply by clicking on the sheet or top area of 'Excel' (menu area) and other times (after it beeps at me for trying that) I have to click on VBA project/editor window and click reset to stop Excel first. When I do the later it is 'running' until I click reset.
When I trace the action in debugger after it exits the last SUB within the process button clik event (end seems normal) that is part of this processing sequence and back to wait for the next form event is where it appears to be 'off doing nothing' but is in fact running something. The tracing stops at that point and waits for the next form action.
I have changed ths settings of app.Calculation & app.Screenupdating in various ways but these do not seem to help.
Any suggestions where I might look.
Thanks
Brian
I also posted this on another form and didn't get any replies, so I appologioze if it happens to be cross-posted but I desperately need advice.
When I trace the action in debugger after it exits the last SUB within the process button clik event (end seems normal) that is part of this processing sequence and back to wait for the next form event is where it appears to be 'off doing nothing' but is in fact running something. The tracing stops at that point and waits for the next form action.
I have changed ths settings of app.Calculation & app.Screenupdating in various ways but these do not seem to help.
Any suggestions where I might look.
Thanks
Brian
I also posted this on another form and didn't get any replies, so I appologioze if it happens to be cross-posted but I desperately need advice.