Name
Hex Function
Syntax
Hex(number
)
-
number
Use: Required
Data Subtype: 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.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 & 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 lngHexValue2 = "&H" & Len(dblNumber) ' Assigns 8
VBA/VBScript Differences
The Hex$
function, which returns a string (as
opposed to variant string) datatype, is not available in VBScript.
See Also
Oct Function |
Get VBScript in a Nutshell 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.