![]() If you’ve got this constant in your basConstants module, then you don’t need these lines of code, just delete them.ĬonAppName = “(Replace this Local Variable with a Global One) ” Normally this constant would be in in a constants module. It has everything to get me up and running straight away just as soon as I’ve downloaded this template into my code window.įirst off it declares a constant. I use this basic function template all the time. However I thought I could do with exposing some of the most useful code I’ve used for years on the web so here it is!. I keep a zipped copy of my folders and files both on my PC and in my Google drive folder. I use the File Insert Option to insert directly into my modules I find it very convenient. ![]() If you happen to be the original author, then let me know and I will give you the necessary attribution. I try and acknowledge the originator of the code where I can.įor some of it I was never able to identify the originator, the original author. Some of the code is not mine, it’s stuff I found useful. I am planning transfer copies of the code from my PC to this webpage, thereby making it available for anyone to use. Over the years I have used this system and built up a comprehensive list of useful VBA code Snippets. Here is a link to the actual tip about inserting code directly into your code module:. ![]() I describe the system on my Nifty Tips Webpage. ![]() Most Microsoft products that use VBA, have a feature where you can store your VBA code in text files and have the code automatically pasted into your code module, with a very simple and easy to use built-in system called:- “File Insert Option” ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |