VBA Code Library

June 1, 2008 at 16:08 · Filed under VBA Examples

Source: johnske, http://www.vbaexpress.com

It’s often a pain to search through workbooks to find a handy procedure you might want to use somewhere else. This Excel code library allows you to save all these handy snippets of code, userforms, and class modules in one location. you can then view the code or run it to see whether it suits what you want to do now. (Note that you can also save your Word, Outlook, etc. modules in here but you generally won’t be able to run them)….MOST of the examples in the attachment are my own code but there are a few that I have picked up from various places. Please note that I often lose track of where I get code samples from, so if you do recognize code that may perhaps be ‘yours’ and it has not been acknowledged therein as such, my sincerest apologies to you, but you do have the small consolation that it has been recognized as being a useful, neat, or otherwise handy piece of code worthy of inclusion in a ‘library’ by a wannabe coder :o) … The code for the library (below) caters for up to 200 procedures, I think if you have any more than that it will become hard to find a given procedure and it would be more advisable to make another library (a copy) to include any further code. NOTE THAT THE CODE BELOW IS FOR YOU TO CREATE YOUR OWN LIBRARY FROM SCRATCH. IT’S ADVISABLE TO JUST DOWNLOAD THE ATTACHMENT AND REMOVE ANY CODE YOU DON’T WANT.

For example workbook: CLICK HERE

Permalink