Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display data from a cell in User Form | Excel Programming | |||
display a user form | Excel Programming | |||
How to display =x/y result in a user form | Excel Programming | |||
Display history in user form | Excel Programming | |||
User Form to display more than 1 reslut | Excel Programming |