Office tutorials

Log VBA function. How to calculate the natural logarithm

1. Log VBA function – Description

The Log VBA function returns value of the natural logarithm. Natural logarithm is based on e number ~ 2.72 (Euler’s number). To calculate natural logarithm value, you should use this function. For example, the value of natural logarithm from 1 is 0.

2. VBA Log function – Syntax

Number: A numeric value used to calculate value of the natural logarithm.

Function return: Double / numeric value.

3. VBA Log function – Example

How to use Log  function  in VBA Excel? The following are examples of using the Exp function in the VisualBasic Editor.

Example 1: Example of using the Log VBA function – result in the MsgBox window.

Example 2: VBA Log – an example of a function – result in Excel spreadsheet.

Excel VBA functions - Log VBA function

Excel VBA functions – Log VBA function

4. VB Log function – Additional information

  • none

5. Log VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.

The article is part of the list of VBA Excel functions. A list of all VBA functions can be found at this address: Excel VBA functions.

1 comment

    • Heels Palace on March 18, 2018 at 9:19 pm


    Hi there, I enjoy reading through your post. I wanted to
    write a little comment to support you.

Leave a Reply

Your email address will not be published.