Excel/Macros Programming At Paharpur Business Centre

Excel/Macros Programming At Paharpur Business Centre

 

About The Event

 

Excel/Macros Programming

Creating & Recording a Macro - First step towards learning Macros programming is to learn how to create & record macros. This is the 1st step towards macro programming.

Executing Macros through shortcuts and command buttons - This is using such features based on user requirements.

Editing recorded syntax - How to edit or write your own Macro programs.

Modules - Learn about modules which is an excellent feature of VBA programming.

Procedures - write & practice programming procedures. Understand their flow.

Sub Procedures - write & practice programming procedures.

Functions - There are certain inbuilt or user defined functions. Explore those functions.

Excel VBA tutorial - VBA tutorial will help you proceed in a step by step approach.

Objects and collections - An object is a special type of variable that contains both data and codes. A collection is a group of objects of the same class. The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

Workbook and workbook objects - A workbook is the same as an Excel file. The Workbook collection contains all the workbooks that are currently opened. Inside of a workbook contains at least one worksheet.

Range object & cells property - Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D.

Methods & properties -Each object contains its own methods & properties. A Property represents a built-in or user-defined characteristic of object.

Object variables and arguments - Sometime a method takes more than one argument. For example, the Open method for the Workbook object, takes 12 arguments. To open a workbook with password protection, you would need to write the code.

If Case, Loop Case & Select Case -Looping, Sub looping, looping through a range, For.Next loop etc. Execute multiple conditions with select statement.

Pricing Details
Rs. 6,000/- Per Person.

Invite friends

Contact Us

Page Views : 370

Venue Map