O'Reilly logo

VBScript in a Nutshell, 2nd Edition by Ron Petrusha, Matt Childs, Paul Lomax

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

Hex Function

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. If the number ends in .5, it’s rounded to the nearest even whole number.

  • 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 statements assigns a hexadecimal value to a variable:

lngHexValue1 = &HFF                    ' Assigns 255

VBA/VBScript Differences

The Hex$ function is not available in VBScript.

See Also

Oct Function

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required