Excel VBA is very helpful for you to do your routine task, create your own function, reduce the manual effort and increase your productivity. With the help of VBA you can customize and manipulate data present in the excel sheet as you want. This book will be very helpful and comes in handy for the beginners who don’t have any programming knowledge. The ultimate aim of this book is to turns the reader to think like an Experienced VBA programmer.

All the topics in this book are elaborated in simple manner for easy understanding. Each and every topic in this book is covered with detailed illustrations followed by output.

What you will learn in this book

1. 
   

   Introduction to Excel VBA-

   
   


2. 
   

   Declaring Variables

   
   


3. 
   

   Working with Ranges

   
   


4. 
   

   If…Else Statements

   
   


5. 
   

   Select Case Statements

   
   


6. 
   

   For Next Statements

   
   


7. 
   

   Do Loops

   
   


8. 
   

   Operators in VBA

   
   


9. 
   

   Understanding the VB Editor

   
   


10. 
    

    Function Procedures

    
    


11. 
    

    MsgBox and InputBox Functions

    
    


12. 
    

    String Functions

    
    


13. 
    

    Information Functions

    
    


14. 
    

    Working with Internet Explorer