Forum Discussion

Tommyjon1982's avatar
Tommyjon1982
Copper Contributor
Jan 16, 2023

VBA 2023 update

I have an excel spreadsheet with lots of macro buttons. I have recently updated excel (Jan 2023) and now the most important button is not working properly. I have spent an entire day trying to fix ...
excel
Macros and VBA
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jan 16, 2023

Tommyjon1982 

I'm not much of a VBA specialist

...but when displaying a UserForm, the event "Initialize" and then "Activate" is executed if it wasn't previously loaded. This is the case the first time the user form is called (even after a STOP), or if the user form was previously closed with a cross or Unload Me.

If the user form was only hidden using Me.Hide, only the "Activate" event is executed the next time the user form is called - but not the "Initialize" event.

 

There is also a command - with which you can make a userform run a code over and over again (interval-technical) - as long as the userform is open.

 

An example in the included file. The OnTime method is used there to update data in the user form at regular intervals. The procedures required for OnTime are usually stored in a general module, which is usually the best experience. These procedures can then be started from anywhere without any problems.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

Resources