Is it possible to run VBA code when i switch the active document?

[torben_schroederXDK86]

Hey.

I have created a userform which helps with saving and exporting the currently active document as needed.

Right now in the userform_initialize sub i have it fill all the textboxes, lables and so on accordingly to the filename and iproperties etc.

I have made it so i can interact with inventor while having the userform open. I can switch the document while its open.

Now i want to know if its possible to re-run the userform_initialize sub when i switch the active document. If so, how? Or are there any other ways around?

(yes i am lazy, thats why i dont want to reopen the userform everytime i want to export/save a new file)

[Michael.Navara]

In general it is possible, but I recommend you to use VB.NET add-in instead of VBA. There are much more possibilities to handle required events like ApplicationEvents.OnActivateDocument, ApplicationEvents.OnNewEditObject, etc.

Also DockableWindow can be useful object.

[Frederick_Law · Accepted solution]

Can't be too lazy.

Add a button in the from to "reload".

I used a form to launch macros, 20 years ago:

Now most of them are addin with icon in Ribbon.

Also using iLogic: