Adding / updating "Project References" in the VBE
A better way to add, update and explore the available "Project References" (Type Libraries and other VBA Projects)
top of page
Blog posts
Search
May 155 min read
The Ribbon and AddIns
How to add Ribbon controls (a button and a ComboBox in this post) to an AddIn
May 131 min read
Tracking your cursor location history in the VBE
When developing code in any modern IDE (integrated development environment), you will always find that your cursor (caret) location is track
May 613 min read
Creating an AddIn in Excel
How to create an Excel AddIn and use it to listen Excel application events using VBA code.
Apr 291 min read
Implement an Interface / Extract an Interface in VBA with VBE_Extras
VBE_Extras can now automatically implement and extract Interfaces for you. Both these functions are in the Refactor sub-menu.
Apr 172 min read
VBA line numbers
What's the point of adding line numbers to VBA code? Only one good reason in my opinion … error handling.
Apr 114 min read
Working with files and folders in VBA
Working with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler
Feb 291 min read
Automatically indenting VBA code
Indenting code ... it's not sexy ... but it does make code much more readable and maintainable when done correctly
Nov 27, 20231 min read
Edit VBA using the full screen - VBE_Extra's FullScreen command
With VBE_Extras, you can go into full screen with one click. And back. As many times as you want.
Nov 9, 20233 min read
Get extended properties for a file
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?
Articles: Blog2
bottom of page