We can use the Special Characters ($ – Dollar Sign, ” – Double Quote, & – Ampersand Sign, ( – Opening Braces, ) – Closing Braces, @ – At the rate Sign) in the Excel Formulas or in the VBA Code, but as their Syntax only. If we want to use them as a character, we'll not be able to use. As using them, will spoil the syntax of the formula and it will through an error. But still Some times we'll be require to use Special Characters in the Excel Formulas or in the VBA Code programming as a character. So in this scenario we can use the ASCII number of those characters. ASCII values can be used to refer the characters in both Excel formulas as well as Excel VBA.
Use of ASCII numbers in Excel Formulas as well as Excel VBA programming:
Excel Formulas : =CHAR(ASCII Number)
Excel VBA : VBA.Chr(ASCII Number)
Below is the list of ASCII keys of few most used symbols which may affect the formula syntax in Excel if they are used as it is:
Use of ASCII numbers in Excel Formulas as well as Excel VBA programming:
Excel Formulas : =CHAR(ASCII Number)
Excel VBA : VBA.Chr(ASCII Number)
Below is the list of ASCII keys of few most used symbols which may affect the formula syntax in Excel if they are used as it is:
Symbol | ASCII Code | Syntax - Excel Formula | Syntax - Excel VBA |
$ - Dollar Sign | 36 | =Char(36) | VBA.Chr(36) |
" - Double Quote | 34 | =Char(34) | VBA.Chr(34) |
& - Ampersand Sign | 38 | =Char(38) | VBA.Chr(38) |
( - Opening Braces | 40 | =Char(40) | VBA.Chr(40) |
) - Closing Braces | 41 | =Char(41) | VBA.Chr(41) |
@ - At the rate Sign | 64 | =Char(64) | VBA.Chr(64) |
No comments:
Post a Comment