There are many starter articles on which can be found with google. check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
More free tutorials and resources available at: http://www.mousetrax.com Essentially the process of learning VBA required that YOU LEARN rather than YOU GET TAUGHT. It is a pull process, not a push process; you pull the knowledge towards you from the help files, the tutorials, the group, Google, etc. The information is all there but you need to get it. It helps the learning process enormously if you have a project. Something real you want to use VBA for. Otherwise you need to find exercises and you will have little real incentive to learn. You can gain a lot of insight about the basics from Dian's tutorials on the websites I mentioned. Beyond that there are four ways you can improve your knowledge and I regularly use all four. 1. Use the Help files in the VBA editor. Although we all grumble about the way Microsoft makes it less easy to use them with each generation of the Office suite, there is an enormous amount of information there with useful examples. You can copy the examples into your code - but you will only learn if when you do so you make sure you understand how they work. 2. Use the group. The best use of the group is when you have written some code which does not do what you want post it to the group with as much details as you can of what you want it to do, what it is doing wrong, and what error messages you get, if any. Also in using the group, read and try to understand all the posts. The questions people ask and the answers given will help you to understand areas of VBA you might otherwise not even realise are there. If you have something you want to do and do not know how to go about it ask the group but make it clear you do not want to have the code written for you, just an explanation of how to write the code. That means you will be writing the code rather than copying it and will have ten times the learning experience! 3. Record macros. Say you want to program an action to change the font color and do not know how to do that, record a macro of changing the font color and then understand the code it generates before putting it into your macro. 4. Google. I use Google a lot to find programming solutions. It can be frustrating as you may not know what words to put in your question but it is well worth persevering, as you will learn different approaches to solving problems and can work out what is best for your situation. One final bit of advice which will save you many mistakes. In the VBA editor go Tools/Options and tick the box for "Require Variable Declarations". This puts "OPTION EXPLICIT" at the top of each module you write and means that you cannot use a variable name without declaring it first. You declare it by using a statement like DIM strMyVar as string. The effect of this is that if you accidentally type stMyVar instead you will get a warning when you compile the macro. (I always go debug/compile on the menu before running a macro as a check.) I hope you do learn quickly. If you have real things to use VBA on, I am sure you will. When you have a little basic understanding please try to answer other peoples questions. It really helps you learn. Keep using the group. Regards David Grugeon On 8 September 2012 19:47, Vijay Kr. Aggarwal <vjaggarwal2...@gmail.com> wrote: > Hello Excel VBA Gurus!!! > > My name is Vijay and currently I am working in MIS Team of a MNC in Gurgaon > from last two years. I have total 8 year experience at all. > > I know little bit macros like recording the macro and using them after > recording. Now I want to learn macros in detail. > > So could you please let me know that shall I join a computer institute to > learn the macros or use only internet to learn macro? > > Please let me know the "institute name" or "Book name" or "eBook Name" or > "Websites links" to learn the Excel VBA macros. > > -- > Regards, > Vijay > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
