JIYIK CN >

We will show you how to call a sub within another sub through examples in VBA.

Calling a Sub in VBA

When dealing with multiple subroutines, we may encounter situations where we need to call multiple subroutines for the same function.

Some functions require writing a lot of code, and to make these codes easy to understand; we need to divide them into multiple parts. We need to call these parts in a single subroutine to ensure that the whole process works in a streamlined manner.

This tutorial will teach us to call multiple subs in a single sub. Let us go through an example in which we will get the sum of multiple columns and then get the sum of multiple sums as shown below.

Sub sumOfA()
Dim result As Double
result = WorksheetFunction.Sum(Range("A2:A8"))
Range("A11") = "Sum Of A"
Range("A12") = result
End Sub
Sub sumOfB()
Dim result As Double
result = WorksheetFunction.Sum(Range("B2:B8"))
Range("B11") = "Sum Of B"
Range("B12") = result
End Sub
Sub totalSum()
Call sumOfA
Call sumOfB
Dim result As Double
result = WorksheetFunction.Sum(Range("A12:B12"))
Range("C11") = "Total Sum"
Range("C12") = result
End Sub

Output:

As we can see from the example above, we want to get the sum of multiple columns, and then we want to get the sum of the sums we got. To do this, we break the code into three different subroutines and call these two subroutines in the last subroutine.

Breaking up your code into multiple functions is a good practice to keep them simple and easy to follow.