Course Overview
Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA! Over the course, we'll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics.
Details of the course is mentioned belowCourse Benefits :
After completion of this course, you will learn how to :
- Collect point by point data utilizing R profiler
- Configure factual programming
- Make utilization of R circle works and investigating deviceq l Understand basic programming language ideas
Course Modules
You will learn :
- Object Oriental Programming
- Collection Object in Real Life
- Objects As Properties
- The Excel Object Model
- Access Object by Name
- Access Default Properties
- The Name Property on Workbook and Worksheet Objects
- Objects and Methods
- - Methods with arguments
- - Method without arguments
- - Method with multi arguments
- - The Object Browser
- - How to call a procedure
- - The TypeName method
- - Variable Declarations
- - Multiple Variable Declarations
- - The Option Explicit Syntax
- - The Byte, Integer and Long Data Type
- - Numeric Data Types
- - Mathematical Operators
- - Boolean operator
- - Date Data Types
- - Quiz for variable and class declarations
- Procedure
- - Variable Scope
- - Call a procedure from another procedure
- - Procedure access level
- Private
- Public
- - When to use Exit Sub
- - Constraints
- - Predefined Constraints
- - Advance Object Oriented Programming
- Application Object
- The Application.Display Alert
- Worksheet Object
- - Range.Select Method
- - Value and Text Property
- - Formula and R1C1 Properties
- - Range Offset Property
- - Range. Resize Property
- - Cells
- - Get Last row of Data in a Worksheet
- Set Theory Primer
- Repeat a task
- For Next Loop
- Step through all items of a collection object
- For Each Loop
- Do Loop
- If then else statement
- Case statement
- Managing Workbook elements and data
- Write a value in a cell
- Cut Copy Paste cell data
- Find values in cells
- Refer to cell using the offset functions
- Concatenating text strings
- Return part of a string
- Managing worksheets with VBA
- Managing workbooks with VBA
- Run a procedure when you open, close, or save a workbook
- Run a procedure when a cell range changes
- Trigger a procedure using a specific key sequence
- Worksheet_Activate event
- Worksheet_Open event
- Worksheet_Change event
- Application.EnableEvents method
- Worksheet_SelectionChange event
- Other Worksheet events
- Label and TextBox Control
- Naming convention
- Design Aesthetics
- Event Procedure to Control
- Activate a UserForm from a procedure
- The Initialize Event
- ListBox Control
- - Wire up a form
- - React to user selection
- - Selecting Multiple Items
- Combobox
- Checkbox
- Capstone Project
FAQ
Any graduate, fresher, experienced and looking to start or change their career into data analytics can attend. No prior experience is mandatory.
Absolutely. We start the training from scratch. After completing the course you will not feel that you have never programmed.
Yes
Our trainers are from the industry. Every class is followed by real time assignments which will make you feel confident when you get into a job.
Fully online. You can attend from anywhere. You just need a laptop and a good internet connection
Yes 100%. It is live and fully interactive. We dont believe in running through power point presentations.
Please contact on the given number.
Contact Us
+91 70198 30464 / +91 79911 97543
Enroll / Enquire
Address : Saroj Iris, No. 106 (Wing A), Gunjur, Varthur Hobli, Bangalore - 560087
Phone : +91 70198 30464 / +91 79911 97543
Email :
info@dakshahanalyticsacademy.com, dakshahanalyticsacademy@gmail.com