Hex Function |
Microsoft.VisualBasic.Conversion
Hex( number )
A valid numeric or string expression
String representing the hexadecimal value of number
Returns a string that represents the hexadecimal value of number
If number contains a fractional part, it will be automatically rounded to the nearest whole number before the Hex function is evaluated.
number must evaluate to a numeric expression that ranges from -2,147,483,648 to 2,147,483,647. If the argument is outside of this range, runtime error 6, "Overflow," results.
The return value of Hex is dependent upon the value and type of number :
number | Return value |
---|---|
Nothing | Zero (0) |
Any other number | Up to eight hexadecimal characters |
If the value of number is known beforehand and is not 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
Oct Function