Home / MS-Excel / General Formatting

VBA Tips

In this tutorial (with the possible exception of the section "Tips for Faster Procedures"), they're indispensable when you do need them. For example, if you want to run your own VBA projects without having to enable the macros every time, you need to digitally sign each project. Similarly, any time you need to store user choices or program parameters, the Registry is the ideal place to do so. And although accessing the file system via VBA sounds hopelessly arcane, you'll be pleasantly surprised at just how often this crucial skill comes in handy. This tutorial covers all these techniques and much more.