Hello all, i have a .swp file (made by myself) which contains two userforms and several modules. These all work together to make 1 macro run. This macro mainly shows userform1 which has several buttons, textboxes, etc.
Now, when i go to Tools>Macros>Run>'that specific .swp file it doesn't launch/initialize userform1, but it runs a sub from one of the modules.
Where can i adjust this, so that it 'starts' with initializing/running userform1?
Thanks in advance,
Arno
This may not be the appropriate technique but it gets the job done. I clarify ambiguity about which sub should run by only defining one public sub called 'main'. If I need another public sub, I define it as a function with no return value specified. Again, probably not the correct approach but it works for me.
As a enhancement, i made sure to only have 1 sub called ´main´ in my whole project.
In this one sub called main, the only code that exists is:
Sub Main
Userform1.show
End Sub
This launches the userform1.initialize event, which is all i wanted to have.
Thanks for your help both of you!
Whenever you run a macro in the manner you describe, it will automatically execute the last sub routine on the main module. You can either do as John suggested and change all the subs to functions except the one you wish to execute on Run or you can move the desired sub to the position that gets automatically run on Run.
Whenever you run a macro in the manner you describe, it will automatically execute the last sub routine on the main module. You can either do as John suggested and change all the subs to functions except the one you wish to execute on Run or you can move the desired sub to the position that gets automatically run on Run.