One of Microsoft Excel’s most powerful capabilities for heavy users is the Visual basic Application (VBA) language. Learning its capabilities is an enormous benefit in almost any field and at all levels of experience. Repetitive tasks can be quickly automated with the Microsoft Excel Macro/VBA. It can be used for various tasks e.g. communicating with databases, analyzing data, automating worksheet construction, modeling and simulation, creating charts/graphs, creating wizards (i.e. dialog boxes), creating graphic user interfaces GUI) and many more.