LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Testing to find if UserForm is Loaded DanB Excel Programming 7 May 16th 23 07:44 PM
UserForm loaded twice in VBA Project Explorer OffDev Excel Programming 2 November 30th 09 05:54 PM
Testing if Userform loaded Nigel Excel Programming 5 May 1st 07 12:55 PM
Extracting Colors from Image loaded in userform emsfeld Excel Programming 6 June 4th 04 04:05 PM
Detecting if a userform is loaded Seth[_5_] Excel Programming 2 November 4th 03 02:59 AM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"