… or in some cases, old but forgotten tricks.
The first comes from a Quora question, asking for the most underutilised feature in Excel.
When de-bugging a VBA routine you can set a break point where the code will stop:
To jump to a different line you can right-click, select “set next statement”, and click the line you want to jump to, but a quicker way is to just click and drag the yellow arrow to where you want to go:
The next is a post from Jeff Weir at Daily Dose of Excel, looking at how to display tool-tips with user defined functions (UDFs). If you enter a UDF name, including opening bracket, then press Ctrl-Shift-A, all the argument names are entered automatically, which can then be replaced with the actual range or value you want:
I had totally forgotten about this, but I must have known about it once, as I have posted two comments on it.
Finally, another tool-tip trick that I had forgotten about, but that has appeared here before. If you hover over a variable whilst de-bugging a VB routine, the first 77 characters of the current value of the variable are displayed as a tool-tip:
If the value is a long string, and you want to see the last 77 characters, hold down the Ctrl key before you hover: