Excel VBA Hex Function

VBA Hex Function: The Hex function in VBA converts the given number into hexadecimal notation and returns the result as a string.

Syntax

Hex (Number)

Parameter

Number (required) – This parameter represents the numeric value that you want to convert to hexadecimal.

Return

This function returns a string value after converting the specified number into hexadecimal notation. If the number is a decimal, it will round it to the nearest integer before converting it to hexadecimal.

Example 1

Sub HexFunction_Example1()
 ' Converting decimal values into hexadecimal notation.
 Dim hex_val As String
 hex_val = Hex(15)
 ' The variable hex_val will return the String "F".
 Cells(1, 1).Value = hex_val
 End Sub 

Output

F

Example 2

Sub HexFunction_Example2()
 ' Converting decimal values into hexadecimal notation.
 Dim hex_val As String
 hex_val = Hex(2000)
 ' The variable hex_val will return the String "7D0".
 Cells(1, 1).Value = hex_val
 End Sub 

Output

7D0

Example 3

Sub HexFunction_Example3()
 ' Converting octal into hexadecimal notation.
 Dim hex_val As String
 hex_val = Hex(&O2751)
 ' The variable hex_val will return the String "5.00E+09".
 Cells(1, 1).Value = hex_val
 End Sub 

Output

5.00E+09