【VBA】Convert binary to decimal

You can convert binary to decimal！

Use the following Worksheet function:
　Bin2Dec Function

Contents

VBA Code
Result
FYI No.1
FYI No.2

VBA Code

You can convert binary to decimal.

Option Explicit

Sub sampleProc()
    
    Dim targetNum As Long
    
    'Set "target binary"
    targetNum = 10101

    'Convert binary to decimal
    MsgBox WorksheetFunction.Bin2Dec(targetNum)
    
End Sub

Set “target binary“(Line 8).

Convert binary to decimal(Line 11).
※argument・・・Set “target binary“.

Result

You converted binary to decimal！

FYI No.1

Also, you can convert decimal to binary！

For more information, see the following article:

【VBA】Convert decimal to binary

You can convert decimal to binary！

FYI No.2

For more information about following, see the following official online manual:

●“Bin2Dec method” of “WorksheetFunction Object”

WorksheetFunction.Bin2Dec method (Excel)

Office VBA reference topic

●BIN2DEC Function

BIN2DEC function - Microsoft Support

The BIN2DEC function converts a binary number to decimal.