How To Create Your Own VBA Code Library In Excel

Once you've started developing VBA applications in Excel it's worth creating your own code library. Reusing procedures and functions makes sense when a little fine tuning is all you need to make the code work for a current project. There are several ways to...

Using A Text Value From A Cell To Run A Procedure In VBA

When you're organizing an Excel application, sometimes it makes sense to store information directly in a separate worksheet or file, rather than accessing everything in code. This article will go one step further and explain how run a macro directly from the text...