John Mallinson
Self-employed VBA developer; VBE_Extras author
📋 Biography
Self-employed VBA developer ... working with VBA in Excel, Word, Outlook and PowerPoint for over 20 years. Previously working for global IT corporations, decided to go self-employed in 2019. For more information on me, see https://www.thevbahelp.com/about VBE_Extras author ... VBE_Extras is an AddIn for the Visual Basic Editor (VBE) within Excel, Word, Outlook, PowerPoint and Access. It makes writing VBA code quicker, simpler and less bug-prone by adding new functionality to the VBE ... the sort of functionality you would expect in a modern code editor. Read more at https://www.thevbahelp.com/vbe-extras
✨ High-Impact Contributions 4
"VBE_Extras – AddIn for the VBE" ... a talk on the new features of VBE_Extras since Access DevCon 2025: * Store / restore cursor location * Add Windows API declarations * F1 to view Windows API web pages * Consts to Enum / Enum to Consts * Alternative VBE window navigation keys * Expand selection / Contract selection * Copy as HTML * Fix case * Auto closing pairs * Math and String "expansions" * Open MS Docs web pages via "Show All Members" and "Info For Code At Cursor". The conference was attended by 140 developers from 12 countries. The conference agenda and other details are at https://www.donkarl.com/devcon/archive/devcon2026.htm and a replay of my presentation can be seen at https://www.youtube.com/watch?v=BbEbMc8xQ9o
My website has a blog via which I provide the community with technical information on VBA development. In the last 12 months I have published 45 VBA-related blog posts … link to blog: https://www.thevbahelp.com/blog. All posts have been re-posted to LinkedIn https://www.linkedin.com/company/thevbahelp/?viewAsMember=true and Bluesky https://bsky.app/profile/thevbahelp.com. Example posts include "Filter a ListBox using a TextBox" (24/2/25), "String interpolation" (7/4/25), "MsgBox with custom button texts" (19/6/25) and "TaskDialogIndirect ... supercharged MsgBox" (30/10/25). In the last 12 months, posts on my blog have received 26,979 views from 14,781 visitors.
Online support to the community via the MrExcel.com Q&A site (profile link: https://www.mrexcel.com/board/members/johndm.195298/). In the last 12 months I have published 103 messages to 57 threads, having had 21 solutions accepted and gained a reaction score of 14.
VBE_Extras is an AddIn for the Visual Basic Editor. It helps developers to write better VBA code. It has a fully-featured 60-day free trial and some functionality is permanently free, including: list / jump to declarations and references; on-screen highlighting; compare Modules; view "TODO"s; create and apply themes; clear the Immediate window; Module and Project picker. Currently 104 users on paid licences. I can't provide a number of "free" users as it can be installed without any contact with me. It is developed in C# using Visual Studio. In development since 2020, with the most recent release in October 2025. Functionality released in the last 12 months includes: auto-closing pairs; alternative navigation keys; automated restore points; expand / contract selection; copy as HTML; add Windows API declarations; F1 to view Windows API web pages.