Name
Hex Function
Syntax
Hex(number
)
number
Use: Required
Data Type: Numeric or String
A valid numeric or string expression.
Return Value
String representing the hexadecimal value of
number
.
Description
Returns a string that represents the hexadecimal value of a number.
Rules at a Glance
If
number
contains a fractional part, it’s rounded automatically to the nearest whole number prior to processing. If the number ends in .5, it’s rounded to the nearest even whole number.number
must evaluate to a numeric expression that ranges from -2,147,483,648 to 2,147,483,647. If the argument is outside this range, runtime error 6, “Overflow,” results.The return value of
Hex
is dependent upon the value and type ofnumber
:
number | Return value |
Null | Null |
Empty | Zero (0) |
Any other number | Up to eight hexadecimal characters |
Programming Tips and Gotchas
If the value of number
is known
beforehand and isn’t the result of an expression, you can represent
the number as a hexadecimal by simply affixing &H
to
number
. Each of the following statements
assigns a hexadecimal value to a variable:
lngHexValue1 = &HFF ' Assigns 255
VBA/VBScript Differences
The Hex$
function is not
available in VBScript.
See Also
Get VBScript in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.