The VBA Help blog

Most VBA developers only ever consume events like Worksheet_Change. But you can declare and raise your own. This post builds a small worker Class that raises events and a listener that handles them ... without the Class knowing who's listening.

Looking for VBA developers who are willing to carry out some testing of VBE_Extras when the VBE is hosted in Autodesk Inventor and / or Autodesk AutoCAD.

mscomct2.ocx contains the Animation, Date and Time Picker (DTPicker), FlatScrollBar, MonthView and UpDown Controls. This post describes how to download and install mscomct2.ocx, and how to add the Controls to the Toolbox and a UserForm.

Sometimes you don't know until run time which method to call ... the name's sitting in a cell, a file, a registry key or a button's Tag. VBA's CallByName turns that String into a call: getting or setting a property, or calling a method, by name.

VBA can tell you the current date and time, but not which time zone you're in, how far that is from UTC, or whether daylight saving is in effect right now. Windows knows all three, and a single call of the GetDynamicTimeZoneInformation Windows API function gets them for you.

VBE_Extras is now able to add 2,538 Windows API Functions (along with 601 Types, 99 Enums and 11,978 Consts) to your VBA code. In addition, VBE_Extras can add (or direct you to) example usages for 757 Windows API Functions.