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

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
Mon Aug 02 10:07:10 CDT 2004

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).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

BRUCE HAMILTON wrote:
> 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!

BRUCE
Mon Aug 02 10:51:13 CDT 2004

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.

"Jay Freedman" <jay.freedman@verizon.net> wrote in message
news:%23%23brlJKeEHA.3132@TK2MSFTNGP11.phx.gbl...
> 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).
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
>
> BRUCE HAMILTON wrote:
> > 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!
>
>