How to use the CByte Function (VBA)

This Excel tutorial explains how to use the Excel CByte function with syntax and examples using VBA.

SUMMARY:

The Excel VBA CByte function converts an expression into a Byte data type. It converts a value to a byte (ie: number between 0 and 255).

For example,

• The VBA Code CByte(10) would return 10.
• The VBA Code CByte(3.95) would return 4.

PURPOSE:

To converts a value to a Byte.

RETURN VALUE:

The CByte function returns a Byte value.

REMARKS:

• The CByte function can only be used in VBA code in Microsoft Excel.
• If the expression can be any numerical value between 0 to 255 (Integer).
• A byte takes up a single byte of computer memory and can have a value from 0 to 255.
• If the expression is not a floating point number then it is rounded to the nearest integer.
• This data type is commonly used for file formats and data conversions.
• An overflow error will occur if the value is out of range.

CByte Function VBA Code example:

Diffrent way to use the CByte function using Excel VBA Code...

CByte Function Example (as VBA code)

The CByte function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CByte function can convert values into Byte data types.

Dim TestCase As Byte
TestCase = CByte(22)

In the above example, CByte(22) would return 22, the variable called TestCase would now contain the byte value 22.

VBA CByte Function Error:

If you supply the CByte function with a numeric value that is less than 0 or greater than 255, you will get the error:
Run-time error '6': Overflow

If you supply the CByte function with a String that cannot be converted to a number, you will get the error:
Run-time error '13': Type mismatch

---

---

Download Example Sample Excel File

CByte-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3… Link 4…