VBScript in a Nutshell

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 of number :

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