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: 7,247
Default UserForm_Initialize

Rob,

The Initialize event is executed when the form is loaded in to
memory, not when it is displayed. Therefore, if you load (or
show for the first time) the form, Initialize will run. If you
then Hide the form and Show it again without Unloading the form,
Initialize will not run. If you need to run Initialize every time
the form is shown, you should Unload the form after hiding it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Rob" wrote in message
...
I've got my UserForm_Initialize event to empty all the
form fields, but sometimes values appear when the form is
loaded. Am I using the wrong event?



 
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
UserForm_Initialize? How to update. Jelso Excel Programming 2 September 5th 03 07:51 AM


All times are GMT +1. The time now is 02:54 AM.

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"