VB & VBA in a Nutshell: The Language

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