This week has been busy and left me with little time to work on finishing up some posts I’ve been working on. Here’s a quick tip that can make coding in VBA or VB6 a little easier. Maybe you already know about it, but it’s something I didn’t learn about until I had been using VBA and VB6 for several years.
When you’re entering code in a VBA code window you get Intellisense help when accessing methods and properties on objects. VB.Net uses intellisense to help you when typing variable names. You can also get help with variable names in VBA, it’s just not automatic like it is in VB.Net. When you’ve typed the first few characters of a variable, press ctrl-space and the intellisense window will display showing you the available variable names that match the characters you’ve typed in so far. You can continue typing to narrow down the list or choose one from the list. Once you’ve selected one from the list by clicking with the mouse or using the arrow keys, press the tab key to use it. An example of its use is shown below.
The written description makes it sound like a bit difficult to use with a lot of steps but it quickly became second nature for me and has saved me a lot of typing.