Home: Welcome

Welcome to the KalpTalk

Blog

Kalpesh Agrawal

Apr 24, 2021

Excel VBA basics [Download] [PDF]

Do you want to quick start with the Excel VBA basics? This book contains more than 75+ VBA topics, which will help you to understand the...

Kalpesh Agrawal

Dec 18, 2020

Create own functions in VBA

You can see many functions like, “SUM”, “MATCH”, and “SHEET” in Excel. You can create your own functions using VBA code. Let’s see an...

Kalpesh Agrawal

Dec 17, 2020

VBA Option Explicit

When Option Explicit appears in code, you must explicitly declare all variables by using the Dim or ReDim statements. If you try to use...

Kalpesh Agrawal

Dec 16, 2020

VBA Select Case Statement

The select case statement is an alternative to the If-Then statement, this allows you to test if conditions are met, running specific...

Kalpesh Agrawal

Dec 14, 2020

VBA Input Box

I hope you know very well how to use a message box, now let’s understand how to use the Input box. The simple Input box example… After...

Kalpesh Agrawal

Dec 13, 2020

VBA If Else Using For Loop

What if we have lots of data? The solution is here! You can solve this problem by using for loop. The scenario is that you are...

Kalpesh Agrawal

Dec 12, 2020

VBA If Elseif Else with AND Operator

We have used the If, Elseif, and Else statement in the last example. You might be thinking that what is the necessity of AND operator....

Kalpesh Agrawal

Dec 11, 2020

VBA If Elseif Else Statement

If there are more than 2 conditions, then we can use the If Elseif Else statement. We are given the below data… Try to run the following...

Kalpesh Agrawal

Dec 10, 2020

VBA If Else Statement

If-else statement: If the condition is true it will display some answer, if the condition is false it will display the other answer....

Kalpesh Agrawal

Dec 9, 2020

VBA If Statement

We will learn simple basic If statement example, to understand well enter the below data in column A1 in your Excel sheet. In the if...

Kalpesh Agrawal

Dec 8, 2020

VBA Immediate Window

To understand Immediate Window with the example first, insert some data in our Excel worksheet. You can directly enter the data in an...

Kalpesh Agrawal

Dec 6, 2020

VBA Breakpoint

In VBA, if you don’t want to execute the full code you can generate a breakpoint. To generate a breakpoint, follow the following steps…...

Kalpesh Agrawal

Dec 5, 2020

VBA Types of Errors and Error handling

There are 3 types of errors in VBA. Syntax errors: These will work for only a single-line statement at a time Compilation errors: These...

Kalpesh Agrawal

Dec 4, 2020

VBA Do while Loop

You may have doubt that what is the difference between do-while and for-loop because both loops do the same thing. The difference between...

Kalpesh Agrawal

Dec 3, 2020

VBA Do until Loop

This loop is reverse to other loops. Do until loop executes the code till when the condition is false, as soon as the condition becomes...

About

Hi, This is Kalpesh Agrawal.

I have cleared 6 Actuarial Exams, including CM1(CT1+CT5), CB2(CT7), CS1(CT3), CS2(CT4+CT6), and CM2 (CT8) all in the first attempt.

Six Sigma Green & Black Belt
Microsoft SQL Server Specialist
Microsoft Excel-2013
Tableau Desktop Specialist

I have work experience as a Data Analyst in an IT company and worked with International Clients. Currently, I am working as an Actuarial Analyst at IIB.

Connect with me on LinkedIn: Kalpesh Agrawal

About Me