VBA Asc function

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 4.33 out of 5)

Asc Function Description

The VBA Asc function returns an Integer value of the character code corresponding to the provided character. The Asc function can be useful to identify the value of a character in VBA. The full list of ASCII character codes can be found here.


The syntax for the Asc function in VBA is:

Asc( string )


A single character for which the ASCII value is to be returned. This function ignores any characters aside from the first provided character in the string.

Other notes

The Asc function can be inverted back using the VBA Chr function.

Example usage

Below are some common Asc function VBA examples.

'Result: 41

'Result: 109

Simply the best place to learn VBA!