John24 hours ago5 minAdding / updating "Project References" in the VBEA better way to add, update and explore the available "Project References" (Type Libraries and other VBA Projects)
John3 days ago5 minThe Ribbon and AddInsHow to add Ribbon controls (a button and a ComboBox in this post) to an AddIn
John5 days ago1 minTracking your cursor location history in the VBEWhen developing code in any modern IDE (integrated development environment), you will always find that your cursor (caret) location is track
JohnMay 613 minCreating an AddIn in ExcelHow to create an Excel AddIn and use it to listen Excel application events using VBA code.
JohnApr 291 minImplement an Interface / Extract an Interface in VBA with VBE_ExtrasVBE_Extras can now automatically implement and extract Interfaces for you. Both these functions are in the Refactor sub-menu.
JohnApr 172 minVBA line numbersWhat's the point of adding line numbers to VBA code? Only one good reason in my opinion … error handling.