Get the number associated tith a character using VBA? (need VBA alternative to "code($)"

[aquixano]

How can I look up the number for a specified character using VBA? On a worksheet, if I have the less than symbol (<) in Cell A1, and put the formula =CODE(""&A1&"") in B1 and it gives me the result 60. With VBA I've tried using application.worksheetfunction but ".code" isn't a choice and I cannot find an alternative way to do it using VBA? Anyone have any suggestions? Thanks for reading!

[Pete_UK]

Why are you wrapping quotes around A1? You could just do:

=CODE(A1)

Hope this helps.

Pete

[aquixano]

sorry, I was trying to illustrate what I was trying do do with VBA and using using the worksheet function as an example with a variable. What I need is code for x = application.worksheetfunction.code(character) But ".code" is not a choice. Hope this clarifies my question. Sorry for the confusion. Let me know if you have other questions. Thanks.

[MrShorty]

If I understand, what you are looking for is the VBA Asc() function.

Asc() function information: https://www.excelfunctions.net/vba-asc-function.html
VBA function list: https://www.excelfunctions.net/vba-functions.html

[aquixano]

Yes, ASC is exactly what I was searching for - Thanks MrShorty!