How to use the ASC Function (VBA)

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

SUMMARY:

The Excel VBA ASC function changes full-width (double-byte) character string to half-width (single-byte) characters.

For example,

• The VBA Code Asc("RA") would return 82
• The VBA Code Asc("ra") would return 114

PURPOSE:

To converts a full-width (double-byte) characters to half-width (single-byte) characters.

RETURN VALUE:

The Asc function returns a Integer value.

REMARKS:

• The Asc function can only be used in VBA code in Microsoft Excel.
• If text arguments does not contain any full-width letters, then the text is not changed.
• The Asc function only change the first character and ignore all of the characters after the first.

ASC Function VBA Code example:

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

ASC Function Example (as VBA code)

The ASC function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the Asc function can convert double-byte characters to single-byte characters

Dim TestCase As Integer
TestCase = Asc("PINK")

In the above example, Asc("PINK") would return the numeric value 80, the variable called TestCase would now contain the integer value 80

---

---

Download Example Sample Excel File

Asc-function-example.xlsm

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