Thread: How do I convert char into integer in Excel VBA?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
raypayette raypayette is offline
external usenet poster
  
Posts: 1
Default How do I convert char into integer in Excel VBA?

Sub test()
MsgBox Asc("a")
End Sub

will display 97 that is the ASCII integer for "a".
Do NOT do this in the spreadsheet: =ASC("a")


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563544

Reply With QuoteReply With Quote