8 VBA Tips Every Programmer Should Know
Voor de VBA programmeurs onder ons…. 8 VBE Tips Every Programmer Should Know
Categorie: Excel
Using Pictures to Create Info-Graph Charts
mmm, interesting: Infographics met Excel pivots, see datapigtechnologies.com!
The Excel VBA Code Cleaner
During the process of creating VBA programs a lot of junk code builds up in your files. If you don’t clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, …
The sequence of events in workbooks
The sequence of events in workbooks 2013/01/31 by frans When you open a workbook Excel not only raises the Workbook_Open event but also a few other events. The same applies to switching worksheets, or closing the workbook. In this post I examine the sequence of activation/deactivation events in an Excel multiple window …