sub executed as the form loads

[Guest]

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

 

[Tom Ogilvy]

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.