top of page
Blog posts
Search
Sometimes it's just the little things - #4: Tasks (aka TODOs)
Tasks, or TODOs, are standard functionality within any "grown up" code editor. But not the VBE. VBE_Extras to the rescue!
Mar 103 min read
0 comments


Sometimes it's just the little things - #3: Alternative VBE window navigation keys
Alternative VBE window navigation keys ... Ctrl+G navigates both to AND FROM the Immediate window, ...
Mar 72 min read
0 comments


Sometimes it's just the little things - #2: AutoText - assignment
Using the AutoText functionality of VBE_Extras, type "=" to create an assignment line for a Function or Property Get
Mar 61 min read
0 comments


Sometimes it's just the little things - #1: Jump back to the last edit location
When you just want to get back to where you were last editing code ... with the click of a single menu item or keystroke ...
Feb 281 min read
0 comments


Filter a ListBox using a TextBox
Show a UserForm with a ListBox which can be filtered by typing one or more characters into a TextBox.
Feb 243 min read
0 comments


Add / remove / re-order parameters ... and update corresponding arguments
VBE_Extras can now help you to add, remove and re-order parameters for a Sub, Function or Property including updating the relevant arguments
Feb 183 min read
0 comments


Commenting / uncommenting VBA code
There are various ways to comment / uncomment code in VBA ...
Nov 6, 20243 min read
0 comments


Get a list of the keyboard shortcuts assigned to VBA macros in Excel
The solution is to use the 'Keyboard shortcuts in this Project' function of VBE_Extras which you identify all such keyboard shortcuts.
Nov 5, 20241 min read
0 comments


Call Hierarchy for a VBA procedure
A Call Hierarchy shows calls of a given procedure by other procedures, and calls from that same given procedure to other procedures.
Nov 4, 20243 min read
0 comments


Dynamically loading a DLL "on-the-fly"
Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.
Oct 2, 202411 min read
0 comments


Articles: Blog2
bottom of page