Populating a ComboBox in the form_Load() or form_Activate() or Form_Initialize() event

[BRUCE HAMILTON]

Help...again!!

I need to populate a combobox as the result of my userform loading. I can
populate the form as a result of a button click event.
I know I have done this before...populated a combobox on form load...but I
can not for the life of me remember what I did. I know it is not
complicated...I think I am just having a major brain fart!!

Thanx in advance for anyones help!

 

[Jay Freedman]

Hi Bruce,

The procedure must be named Userform_Initialize() or Userform_Activate().
These names are the same for all userforms regardless of the actual name of
the userform. The difference between them is that the Initialize event fires
when the userform is loaded into memory, while the Activate event fires just
before the dialog appears on screen (and may occur several times if you hide
and show the dialog without unloading it).

 

[BRUCE HAMILTON]

Jay,

Thank you...I knew it was something extremely simple that I was
missing....the generic Userform name instead of the form specific name.

Thanx again.