John6 days ago1 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.
JohnApr 113 minWorking with files and folders in VBAWorking with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler
JohnFeb 291 minAutomatically indenting VBA codeIndenting code ... it's not sexy ... but it does make code much more readable and maintainable when done correctly
JohnNov 9, 20233 minGet extended properties for a fileIt'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?
JohnOct 23, 20232 minVBA - highlighting references in the VBEIn any modern code development tool, you can highlight all on-screen references of a code member. With VBE_Extras, so does the VBE!