Hex, Hex$ Functions |
Named Arguments
No
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.
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 of number :
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 two statements assigns a hexadecimal value to a variable, for instance:
lngHexValue1 = &HFF ' Assigns 255 lngHexValue2 = "&H" & Len(dblNumber) ' Assigns 8
See Also
- Oct, Oct$ Functions
Get VB & VBA in a Nutshell: The Language 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.