I’m pretty busy today so here’s a quick VBA tip.
We all know if you hover over a variable in VBA (while in debug mode) you can see the value of that variable. This allows you to see the values that are being passed in and out of variables – very useful. But by my estimation, these tooltips can only hold 77 characters (including the variable name). This basically means if the value in your variable is too long, it gets cut off.
Here’s an example. Hovering over the variable TempDataFile allows me to see the string that represents the file name, but that string gets cut off.
Although there is no way to tell Excel to show more than the first 77 characters, there is a trick you can use to see then last 77 characters.
Simply hold down the CTRL key while you hover. As you can see, this allows me to see the last part of the file name.