Vanishing Form (behind WS I guess)

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.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Not 100% on this but as no one else is playing have you looked into the modallity of the form, I dont fully understand how it works but I know it has to do with the continued visibilty of the form or not
 
Upvote 0

Forum statistics

Threads
1,224,518
Messages
6,179,254
Members
452,900
Latest member
LisaGo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top