In this session we will briefly discuss and see the different things which we are required to learn to Record Macros. The idea of this tutorial is to help you to get overall idea about Excel Macros and what are the things which we are going to cover in part of learning basic macro tutorials.

As discussed in the introduction part, in these basic tutorials you are going to learn how to record a macro and how to change the code as per your requirement.
You need to know the following thing to learn recording a Macro.

Excel Macros in Nutshell: Getting Started with Excel VBA Macros : Concepts

VBA Environment:

In this session we will see the VBA environment and what are the different object are available in VBA, which helps you to be confident about VBA and its Object.

Step By Steps Learning Recording a Macro:

In this session we will see step by steps of howto record a macro, we will take an example and we will practice it to be comfortable in recording macro.

Writing Your First VBA Macro- Hello World!

In this session you will write your first macro, instead of recording a macro. This helps you to be familiar with VBA Editor.

Debugging VBA Code

In this session we will discuss about how to debug and different command and short-cuts to debug a macro.

Debugging VBA Code

In this session we will discuss about how to debug and different command and short-cuts to debug a macro.

Accepting Values (Input Box) & Popup Messages (Message Box)

In this session we will learn accepting the data from the user and display a message to the user.

Modifying and Commenting Macros or VBA Code

In this session we will see how to modify an existing macro and how to comment the macro statements.

Executing a Macro

In this session we will see the different ways of executing the macros.

Macro Security

In this session, what is the macro security and what should we do when excel is prompting for enable the macros.

Learn Macros with Examples – 15 Basic Macros for Absolute Beginners

We will see the 15 basic macro example which will make you confident in writing basic macros in excel.

Premium Project Management Templates

120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

50+ Essential Project Management Templates

Excel | PowerPoint | Word

VIEW DETAILS

Project Portfolio Management Templates

Excel | PowerPoint Templates

VIEW DETAILS

50+ Excel Project Management Templates

Excel Templates

VIEW DETAILS

By Published On: February 9th, 2013Categories: Excel VBATags:

Share This Story, Choose Your Platform!

About the Author: PNRao

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).