sub executed as the form loads
 

It's quite a stupid question...
how do i get to run a sub as the form loads?

smth like

sub myform_initialize()
or
sub myform_load()

but it doesn't work...

sub executed as the form loads
 

The initialize event is always named

Private Sub Userform_Initialize()

and you can use that to run your code. It is always best to enter event
declarations by selecting them from the dropdowns at the top of the module.
Then you wouldn't have tried to use a name like myfornm_initialize().
There is no Load event - that is what initialize is.


There is an Activate event.
--
Regards,
Tom Ogilvy

"snaggy^^" wrote in message
...
It's quite a stupid question...
how do i get to run a sub as the form loads?

smth like

sub myform_initialize()
or
sub myform_load()

but it doesn't work...