This is the code I use to hide a userform whether it is done by hitting the "Close" button or the "X" at the top right. For some reason when I use the close button then re-open the form it will still show all the typed data that was on the form before closing if I had not submitted it. This does not happen when I hit the X however, when I re-open the form it is once again blank. Anyone know why or where the fault is in my code?
Please Login or Register to view this content.
Last edited by nohero; 07-05-2011 at 04:05 PM.
Hi nohero,
I'm not a programming wiz, but the code linked to your command button is simply hiding the form, not closing it and releasing it from memory.
When you close a form via the 'x', even though you added code to hide the form, the form will actually be closed and the memory released.
Does anyone know of a way to make the little red X not actually close the form and just hide it? The reason I want to hide instead of unload is because of a bug that I have not found a resolution for described here:
http://www.eggheadcafe.com/software/...-error-75.aspx
It only affects one of the 6 systems in my office but it is still a nuisance for that one user. The workbook works fine for everyone else but will cause run time error 75 when a userform is unloaded then the user tries to load it again after a few minutes.
The OP from the link I posted determined that hiding the forms is a somewhat usable workaround for the issue and from testing it I found that it does work. Now I just have to tie it in to the X as well as the close button.
Ideas on how to do this?
Before someone suggests I have that one user NOT hit the red X I just want to add that other users will be working from this machine in the future as well as multiple other systems at our other office for which I still have not determined how many systems will have the same bug.
In the QueryClose code, insert
Notice one of the parameters in the QueryClose function is "Cancel as Integer". When Cancel = 1 (TRUE) the Close does not occur. When it's 0 (FALSE), the close occurs.Please Login or Register to view this content.
You need:
to stop the form from being unloaded.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks