ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Aborting a User Form display (https://www.excelbanter.com/excel-programming/422357-aborting-user-form-display.html)

Don Wiss

Aborting a User Form display
 
Before I display a User Form I try to do all the edits first, so to not
display the form for invalid situations. But some times it is more
efficient to do the edits in the initialization code. Is it then possible
to abort and not display the form?

Don <www.donwiss.com (e-mail link at home page bottom).

joel

Aborting a User Form display
 
Use Load and Unload along with show and hide. Load will initialize the form
but not display the form. You can put the show in the initialization code
after you do the edits.

"Don Wiss" wrote:

Before I display a User Form I try to do all the edits first, so to not
display the form for invalid situations. But some times it is more
efficient to do the edits in the initialization code. Is it then possible
to abort and not display the form?

Don <www.donwiss.com (e-mail link at home page bottom).



All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com