Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last updated: May 27, 2022

VBA in Excel

In this Module, we are going to take a brief look at VBA which is Microsoft’s Programming Language for excel, and discuss some of the available functions.
Introduction to Excel VBA
In this blog, we will be studying a detailed description of Excel VBA.
Introduction to Macro EASY
In this article, we will discuss how to create and perform some other functions on the macro in the Excel sheet.
MsgBox and InputBox in VBA EASY
In this blog, we will discuss the uses and basic syntax of MsgBox and InputBox functions of Excel VBA along with their differences.
Workbook and Worksheet Object EASY
In this blog, we will discuss the differences between Workbooks and Worksheets and their important methods, in continuation with a discussion of loops and working with files and preparing charts in Excel.
Range Object EASY
The Range object is the most significant object in Excel VBA since it represents cells on your worksheet. In this article, we will learn about the properties and functions of the Range objects.
Variables EASY
In this blog, we will be studying the declaration and initialization of variables in Excel VBA.
If Then Statement EASY
In this blog, we will be studying the use of the If-Then statement in Excel VBA.
Loop EASY
In this blog, we will be studying different types of loops in Excel VBA.
Using Macro Errors in VBA EASY
This blog will go through various strategies for using debugging errors and macros in Excel VBA.
Using Strings in VBA EASY
In this blog, we will take a look at how strings and their operations are used in Excel VBA.
Date and Time in Excel
In this blog, we will learn various operations that can perform with date and time in Excel. First, we will learn to print simple dates, then compare them, find weekdays between some dates, delaying, find the frequency of occurring of a particular year, sort birthdays, and all this with examples to understand better.
Events in Excel EASY
In this blog, we will learn events in excel with different examples and scenarios like DoubleClick event, creating a footer, highlighting the active cell, and some applications in problems.
Array in VBA EASY
In this blog, we have discussed Arrays in VBA, How they are used, and the main differences between the One Dimensional and Two-dimensional arrays, concluding with the Inbuilt array Function and Size of the array.
Functions and Sub in Excel
This blog discusses functions and sub, including the difference between these and how we deal with them in excel VBA.
Application Object
In this blog, we will learn about application object, their different functions, and their different properties like status bar, reading data from text files writing data to the text file, and vlookup. We will understand all these with good examples and pictorial representation.
ActiveX Controls
In this blog, we will learn about ActiveX Controls like text boxes, command buttons, list boxes, etc., with the proper method to set them up and use them with code in VBA. To sum up, we will also learn how to make a loan calculator.
Userforms
In this blog, we will learn about user forms in excel in VBA, ranges in VBA,  with multiple applications, and all of this with their pictorial representation and proper code.
Web Scraping with VBA EASY
This blog will contain the Web Scraping technique with VBA in detail.