Blog posts

It's fairly straight-forward to get the basic properties for a file, but how do you get the extended properties for a file with VBA?

In any modern code development tool, you can highlight all on-screen references of a code member. With VBE_Extras, so does the VBE!

Need help with installing an AddIn in Excel, Word, PowerPoint or Outlook? Get the AddIn Assistant!

Using the Mandelbrot Set to demonstrate the relative speed of using C# code via COM Interop from VBA.

Since mid 2022, files containing VBA code received over the internet or via email can be 'blocked' - preventing the VBA code from running.

Fed up with arrays and Collections (and Dictionarys and ArrayLists)? Try List, a better collection for VBA.

Application.OnTime is great if you want to call your procedure to the nearest second. What do you do if you want finer control than that?

Want a better way to clear or scroll to the end of the Immediate window ... manually or automatically when you run code ... read this!

Multiple choice UserForm in VBA using a ComboBox - this UserForm allows a user to make a choice when there are more than just Yes/No or OK/C

VBE_Extras includes functions for 'Matches for literal value at cursor' and 'Extract to constant' which are closely related.