Vba introduction

VB

1. VBA Introduction

2. Excel VBA is the coding language of Excel. VBA stands for Visual Basic for Applications and is actually Microsoft’s general programming language for all Office Applications What is VBA

3. Objects in VBA Macros

4. This course concentrates on you writing VB Code. You will learn to create Automations In Excel For Example; How to get Data from multiple Excel files and make a single file our of them, by a click of a Button. Macro Recording Complete Complex task Reusable Code Speed Work What will you Learn

5. MsgBox

6. Comments

7. InputBox

8. Assign a macro to a Button Select the macro name Click on OK Button Invoking a procedure

9. Remarks: Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster. Remember to set the Screen Updating property back to True when your macro ends. Application.screenUpdating

10. User - Defined Functions(UDFs)

11. Just like a built-in function, a UDF is a pre-defined formula which can be executed in the same way. The difference is that you design the definition using VBA. In this way you can define functions which do not exist as built-in functions, but which you may need to use frequently. What is a UDF?

12. You use a UDF for the same reason as a built-in function, namely to make calculations (operations) which are repeated more efficiently. Before writing a UDF make sure that it does not already exist as built-in Excel function! When and why do you use a UDF?

13. Function name [(arguments) [ As type] ] [ As type] [statements] name= expression [ End Function ] User Defined Function Syntax:

14. Function multi2num(x As Integer,y As Integer) As Integer Multi2num = x + y End Function Example :

15. Write a Function to check whether the number is Even or Odd. Write a function for number between 1-17 should return “young”, 18-40 should return “middle age” and above will be Senior Citizen. Write a Function for Cube of a Number Exercise

16. Calling a Procedure in Some other Pocedure

17. VBA Arrays

18. Remove Duplicates

19. Error Handling

20. Example

21. Example

22. Events