How to type Unicode currency character in Visual Basic Editor

by

VBA editor is not Unicode.

In order to have Unicode characters in it, you need to use ChrW$, e.g.

Dim Rupee As String
Rupee = ChrW$(&h20A8&)

Also see Unicode string literals in VBA.

More Related Contents:

  1. TextJoin UDF For Excel 2013
  2. Remove Duplicates from range of cells in excel vba
  3. How to copy cells that contain certain text to another worksheet [closed]
  4. Loop Through All Subfolders Using VBA [duplicate]
  5. What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?
  6. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  7. How do I base64 encode a string efficiently using Excel VBA?
  8. Too few parameters Expected 1, recordset issue
  9. Save attachments to a folder and rename them
  10. Using VBA to get extended file attributes
  11. VBA- variable in a range, inside a formula
  12. How to Lock the data in a cell in excel using vba
  13. Outlook Reply or ReplyAll to an Email
  14. How do I use variables to set properties in VBA (Excel)
  15. Check for the senderEmailAddress
  16. Removing a string that includes CRLF characters from body of e-mail
  17. Workbooks.Open Method in VBA
  18. Windows().Activate works on every computer except one
  19. VBA: How long does On Error Resume Next work?
  20. VBScript to open a dialog to select a filepath
  21. How can I create text files with special characters in their filenames
  22. Open a workbook from VBA and disable Workbook_Open() code?
  23. Creating form programmatically in the module using vba
  24. Macro to update all fields in a word document
  25. How to filter listbox values based on a Textbox value
  26. How to get the procedure or function name at runtime?
  27. Copy an array reference in VBA
  28. How to get selected value in multicolumn listbox
  29. What does the To and Step mean in VBA?
  30. Query my excel worksheet with VBA

Leave a Comment