Blog posts

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.

Sorting arrays of Objects in VBA - any Objects, Worksheets, Documents, Slides etc or Objects defined by your own custom Class Modules