【VBA】Convert decimal to binary

You can convert decimal to binary！

Use the following Worksheet function:
　Dec2Bin Function

Contents

VBA Code
Result
FYI No.1
FYI No.2

VBA Code

You can convert decimal to binary.

Option Explicit

Sub sampleProc()
    
    Dim targetNum As Long
    
    'Set "target decimal"
    targetNum = 10

    'Convert decimal to binary
    MsgBox WorksheetFunction.Dec2Bin(targetNum, 6)
    
End Sub

Set “target decimal“(Line 8).

Convert decimal to binary(Line 11).
※1nd argument・・・Set “target decimal“.
※2nd argument・・・Set “number of digits”.

Result

You converted decimal to binary！

FYI No.1

Also, you can convert binary to decimal！

For more information, see the following article:

https://excel-vba-codes.com/how-to-convert-binary-to-decimal/

FYI No.2

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

●“Dec2Bin method” of “WorksheetFunction Object”

WorksheetFunction.Dec2Bin method (Excel)

Office VBA reference topic

●DEC2BIN Function

DEC2BIN function - Microsoft Support

The DEC2BIN function converts a decimal number to binary.