Blog posts

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

Apr 11, 20244 min read

Indenting code ... it's not sexy ... but it does make code much more readable and maintainable when done correctly

Feb 29, 20241 min read

With VBE_Extras, you can go into full screen with one click. And back. As many times as you want.

Nov 27, 20231 min read

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?

Nov 9, 20233 min read

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

Oct 23, 20232 min read

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

Sep 21, 20231 min read

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

Sep 15, 20232 min read

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

Sep 12, 20236 min read

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?

Aug 31, 20233 min read

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

Jul 28, 20233 min read

Articles: Blog2