Use VBA Code in Excel

Visual Basic for Applications extends the function of Excel to enable you to exploit programming functions, such as loops and cell addressing which would otherwise be difficult or impossible. It can also be used to build your own functions to extend those already supplied. If you want to learn Visual Basic, it is really best to ask yourself first (a) whether you need it and (b) what do you need it for. There is no harm, of course, in learning a programming language purely out of interest but unless you have a goal in mind, your learning is likely to be slow. There are plenty of excellent tutorials, both online and in books, on using VBA in Excel (and other MS Office applications) and the best thing to do is to search for them, use a few and stick with the one which seems to suit you best. You may find that a (physical) book is easier to use than an online tutorial and the best place to start is your local library. If they don't have a particular book, they can usually order it from the library system. The "... For Dummies" series are usually quite good. It's rather important to know what version of Excel you have (and therefore what version of VBA you are using). Most older code is compatible with later versions, at least when you are learning the basics, but if you have a tutorial for a later version than yours, you are likely to find that there are slight differences which may mean that the examples in the tutorial won't work as expected.

Well, first you have to enable Show Developer Tab In The Ribbon from the Office Button -- Excel Option or you can use the keyboard shortcut Alt + F11 in order to show VBA window you can learn how to use VBA code here : http://www.mrexcel.com/archive/VBA/index.html