Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro get executed twice | Excel Discussion (Misc queries) | |||
part of a code not being executed | Excel Programming | |||
No file when Save As is executed | Excel Programming | |||
No file when Save As is executed | Excel Programming | |||
Beginner question: where to put code when form loads | Excel Programming |