VBA Window

[emilyebba]

Hi...Just a couple of general VBA window questions. Does it matter what order the Event Procedures are in in the VBA window? Along that line does it matter of how much code you have in there? Will it make the database slower?

Thank you

 

[Galaxiom]

By default they are in alphabetical order but many developers group them by functionality. The free must-have utility MZ-Tools has a tool for efficiently reordering them.

Too much code slowing down performance? Not significantly per se. Of course if you have a vast number of lines becuase you write clumsy code then that would slow it down.

I expect there will be some limit to amount of code. Definitely when you reach the 2GB limit of the Access file but that would be a truly terrifying amount of code.

You can "only" have 1000 modules.

 

[emilyebba]

Thank you kindly for your answer! Helped a lot! Wow 1000...I cant even imagine.