VBA EXP Function in Excel (5 Examples)

VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function in VBA is and how to use it with examples.

Download Workbook

You can download the free practice Excel workbook from here.

Introduction to the EXP Function in VBA

The Exp function in VBA returns a double value of the exponential function e^x (mathematical constant e, the base of natural logarithms) raised to a supplied power for the given value of x.

• Syntax

Exp(number)

• Argument

• Return Value

A double numeric value.

5 Examples of VBA EXP Function in Excel

In this section, we will show you how to use the Exp function in VBA with 5 easy examples.

1. Find the Exponential Value of -5 with VBA in Excel

Steps to find the exponential value of -5 with VBA are given below.

Steps:

• Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open Visual Basic Editor.

• In the pop-up code window, from the menu bar, click Insert -> Module.

• Copy the following code and paste it into the code window.

'Find the Exponential value of -5
Sub ExpOfMinusFive()
    'Variable declaration
    Dim iVal As Integer
    Dim iResult As Double
    iVal = -5
    iResult = Exp(iVal)
    MsgBox "The Exponential value of -5 is : " & iResult
End Sub

Your code is now ready to run.

• Press F5 on your keyboard or from the menu bar select Run -> Run Sub/UserForm. You can also just click on the small Play icon in the sub-menu bar to run the macro.

You will get the exponential value of -5 in the Microsoft Excel message box.

Read More: How to Use VBA IsNumeric Function (9 Examples)

2. Determine the Exponential Value of -0.3 with VBA EXP Function

Steps to find the exponential value of -0.3 with VBA are given below.

Steps:

• Same way as before, open Visual Basic Editor from the Developer tab and Insert a Module in the code window.
• In the code window, copy the following code and paste it.

'Find the Exponential value of -0.3
Sub ExpOfMinusZeroPointThree()
    'Variable declaration
    Dim iVal As Integer
    Dim iResult As Double
    iVal = -0.3
    iResult = Exp(iVal)
    MsgBox "The Exponential value of -0.3 is : " & iResult
End Sub

Your code is now ready to run.

• Run this code and you will get the exponential value of -0.3 in the Excel message box.

Read More: How to Use VBA Val Function in Excel (7 Examples)

3. Check the Exponential Value of 0 with VBA EXP Function

Steps to find the exponential value of 0 with VBA are given below.

Steps:

• Previously shown, open Visual Basic Editor from the Developer tab and Insert a Module in the code window.
• In the code window, copy the following code and paste it.

'Find the Exponential value of 0
Sub ExpOfZero()
    'Variable declaration
    Dim iVal As Integer
    Dim iResult As Double
    iVal = 0
    iResult = Exp(iVal)
    MsgBox "The Exponential value of 0 is : " & iResult
End Sub

Your code is now ready to run.

• Run this code and you will get the exponential value of 0 in the Excel message box.

Related Content: How to Use Fix Function in Excel VBA (4 Examples)

Similar Readings:

• Use VBA Case Statement (13 Examples)
• How to Use IsDate Function in VBA (3 Examples)
• VBA If – Then – Else Statement in Excel (4 Examples)
• How to Use VBA TimeValue Function (6 Relevant Examples)
• Use VBA Mod Operator (9 Examples)

4. Compute the Exponential Value of 0.1 from a Cell in Excel

To compute the exponential value of 0.1, we will store the value in a cell first then run the VBA code this time.

Notice in the above example, where we stored the value 0.1 in Cell B5. We will extract the exponential value of 0.1 in Cell C5.

Steps:

• Open Visual Basic Editor from the Developer tab and Insert a Module in the code window.
• In the code window, copy the following code and paste it.

Sub ExpOfZeroPointOne()
    Range("C5").Value = Exp(Range("B5"))
End Sub

Your code is now ready to run.

• Run this code and you will get the exponential value of 0.1 in Cell C5.

Read More: Excel Formula to Generate Random Number (5 examples)

5. Calculate the Exponential Value of a Range of Cells with VBA in Excel

By following the code shown in the previous point, you can calculate the exponential value for a range of cells in Excel.

We will calculate the exponential value for the numbers shown in the picture above with the VBA code. You can store any numeric value in your dataset according to your need.

Steps:

• Open Visual Basic Editor from the Developer tab and Insert a Module in the code window.
• In the code window, copy the following code and paste it.

Sub ExpValueVBA()
    Range("C5").Value = Exp(Range("B5"))
    Range("C6").Value = Exp(Range("B6"))
    Range("C7").Value = Exp(Range("B7"))
    Range("C8").Value = Exp(Range("B8"))
    Range("C9").Value = Exp(Range("B9"))
    Range("C10").Value = Exp(Range("B10"))
End Sub

Your code is now ready to run.

• Run this code and you will get the exponential value of all the numbers stored in the cells of the dataset in the cells mentioned in the code.

Read More: Exponential Notation E in Excel & How to Turn Off Auto Scientific Notation!

Things to Remember

• The value of constant e is approximately 2.718282
• If the value of the argument number exceeds 709.782712893, VBA will return a run-time 6 error.
• If the value of the argument number is an unrecognized number or string, then VBA will throw a run-time 13 error.
• This function integrates the action of the LOG function and is sometimes assigned to as the anti-logarithm.
• The LOG function can be used to return the natural logarithm of a number.

Conclusion

This article showed you how to use the VBA Exp function in Excel. I hope this article has been very beneficial to you. Feel free to ask if you have any questions regarding the topic.

Related Articles

• How to Use ABS Function in Excel (9 Suitable Examples)
• Excel VBA ASC() Function – Get ASCII Value of Character
• How to Create a Body Mass Index (BMI) Calculator in Excel Using VBA
• 44 Mathematical Functions in Excel (Download Free PDF)
• How to Use Excel PI Function (7 Examples)
• Solving equations in Excel (polynomial, cubic, quadratic, & linear)
• How to Use POWER Function in Excel (5 Suitable Examples)