My training was different. I initially learnt VB6 and then moved into VBA when I started my career. Trust me while I say this: I had to struggle to understand the way VBA works as opposed to VB6. Since I learnt VB6, it was somewhat easy to work with VBA. It is only the logical thinking and the Basic Foundations that made me strong in this. And if you ask me any theoretical question, I may not be able to answer. But deep down, I know I can get a solution to a problem. When I write a code, I always say that it (the code) is not a perfect code, but the best code. You always need to find time to revisit your old code and try to modify them more to your requirement. Let me tell you my motto – “Why work, when the system can work for you?” With this statement, you can understand what kind of a man I am. Let me be bold to say this: “Yes, I am LAZY!” By this, I started automating my regular chores at my office. Above all, Practice. This makes you perfect. It is not that you just learn or read about something or some function in VBA and just leave it off! You need to start thinking how you could use it and how you could modify it for your requirement. If you don’t get a solution, break your problem into pieces and try to solve them one-by-one. At the end, you’ll get your solution. I also say this, make sure you have more than one (many) way(s) to solve your problem. Because, if one way fails, you have the other ways. No book or website(s) will help you to be great. It’s your logical thinking and practice that makes you good (not perfect!). Internet is a great resource. But not “The Resource”. Use it for your requirement. Modify the code per your requirement. Remember there may not be any direct resolutions found on internet for your problem. You will get your solutions in bits and pieces. Merge them to get your solution. I tell this to everyone who think they can come into limelight once they learn VBA. But that’s not true. You have to fight/struggle with the system. You have to show the system that you are the best. And, in order to be the best, you should prove yourself (again and again). I am not a theoretical person. I am practical. I love what I do and I live for it. I know there are few people who teach VBA for people to learn. But most of the times, I’ve seen faculties teach VBA just for money. They do not care if people have learnt or not. I feel sad and sick about this. But hoping one day we will find some people who will teach wholeheartedly VBA where the rest of the world will learn and excel in this beautiful programing language, VBA.
You need not get recognized by the management. Once you are well known with your peers and colleagues, you are automatically in the limelight, whether your managers/seniors recognize you or not. Word of mouth spreads faster than emails and recognitions. (Don’t look for recognitions, you are here to learn. Every new thing is a learning for you. If you start looking for recognitions, you are deviating from your path.) Chances are that even people from other processes come and ask for your help.
Don’t learn VBA as a stepping stone to next level of your career. I’ve seen people just doing that. Once you move to the next level, you will not look into VBA anymore. Because, your next level job will have more work than you have in your current level. Probably, you may have time in the beginning. But, later, you’d not. It’s very rare to find a person who’s still continuing to work with VBA and in management level. Let me tell you my story. I am still an associate (since 2000! Now, can you believe that!?). I did not want to move into management role because I believed that if I make that move, I’d lose my grip on VBA. And, guess what? That paid off! I had chance to work with different applications in different organizations. And, I am proud of that. I don’t want to block your career, it’s entirely in your hands.
A few things to remember while entangling yourself in corporate politics:
• Make sure you are constantly in touch with your manager about what you are doing.
• Whatever work you are doing, make sure that it is in on papers and your management is agreeing for it. If not, it is better not to take up. Let someone else take it.
• Make sure the work you did and the talent you have is recognized by the management.
• Remember, nothing is for free. You do something, you get recognized for that.
• Don’t go for someone else’s idea. If the idea is already done and implemented, think which way you can improve it. Trust me, nobody likes negatives on their project. So, use your words wisely to make them understand what improvements you want to have in their project. Also, indulge yourself in the project so that your feedback is also taken and implemented.
• Your idea should be new and innovative, just like the “Hatt ke” types. Your thoughts should be different from others. Your coding skills must be way above than the ones who are presently writing codes. People should say, “Yes, this is what we are looking for”.
• Become a redeemer for your process. Be with them when they need you. They should look at you if they need any automation. Doesn’t it sound nice when you and your team does something without anybody’s help and present it to the management? (Team work is important too!)
Above all, PATIENCE, my friend, Patience! That will take you to a lot of places. Learn patiently, you have your days. Remember the saying: “Every dog has its day!” and the famous dialog in 3 Idiots “Success ke peeche mat bhago. Kabil bano. Success toh jhak marke ayegi!” (Translation for others who didn’t understand: Don’t run behind success. Try to achieve excellence. Success will come looking for you.) It may sound like as if I am a fool. But, trust me, people who worked with me know what I am.
One last thing. BE UNIQUE! People will try to copy your codes. That’s ok (it’s natural!). They are copying from you. Infact, you are giving your codes for their work. Be happy! Though they might not tell you, others know whose codes they are. I also faced this problem. But a manager of mine once told me this: “You are Black Cat. The rest are Copy Cats. You are unique.” That’s true, I’m unique. My coding style is different from others. Everybody knows who I am and what I am capable of. So, my dear people, never worry for anything. You are learning VBA to enjoy! Not to sit and cry.