Excel VBA: A Beginners' Guide

Rajan

• 05 oktober 2015
• 9781310799624

Samenvatting:

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