Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Constantly loaded userform??
When Workbook_Open() is called, I plan to immediately
load one of my userforms. Is it possible to load a userform as invisible?? Eventually I will make the userform visible to the user, but if they press the "X" button I do not want to kill or unload the userform... I just want to make the userform invisible again if a user presses "X". So, in essence, my userform is going to be constantly loaded as long as the workbook is open...I don't want it to ever be killed or unloaded, merely just toggled between visible and invisible. Is it possible to implement something like this??? Any code examples? thank you everyone. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Constantly loaded userform??
there are 4 commands you use with a USERFORM UserForm1.Show Userform1.Hide Load Userform1 Unload Userform1 You can also include an initialize function for each userform Sub UserForm_Initialize() the initilize function only gets called the first time the show command or Load function is called or the 1st time after an Unload is performed. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160000 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing to find if UserForm is Loaded | Excel Programming | |||
UserForm loaded twice in VBA Project Explorer | Excel Programming | |||
Testing if Userform loaded | Excel Programming | |||
Extracting Colors from Image loaded in userform | Excel Programming | |||
Detecting if a userform is loaded | Excel Programming |