Skip to main content

Hex function

Table of contents
  1. Syntax
  2. Remarks
  3. Example

Returns a String representing the hexadecimal value of a number.



The required number argument is any valid numeric expression or string expression.

If number is Hex returns
-2,147,483,648 to 2,147,483,647 Up to eight hexadecimal characters
Null Null
Empty Zero (0)


If number is not a whole number, it is rounded to the nearest whole number before being evaluated.

For the opposite of Hex, precede a hexadecimal value with &H. For example, Hex(255) returns the string FF and &HFF returns the number 255.


This example uses the Hex function to return the hexadecimal value of a number.

Dim MyHex
MyHex = Hex(5)    ' Returns 5.
MyHex = Hex(10)    ' Returns A.
MyHex = Hex(459)    ' Returns 1CB.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>