CODEWITHSUNDEEP
vbaexcel-2013currency-formatting
Kannan
Kannan

Reputation: 31

How to type Unicode currency character in Visual Basic Editor

There is a project requirement where we need to check a cell for its currency type.

I came across a similar question in this forum (How to check if cell is formatted as Currency?). It explains how to do that for the $ symbol. But I couldn't replace the $ symbol with other currency symbols (for example Indian Rupee, Euro etc.) in Visual Basic Editor. To have other symbols in VBE I have tried the following:

But it is pasted as ? in VBE.

Please help me to have currency symbols in VBE. If the above is not possible please suggest a way to identify the currency type of a cell.

Upvotes: 3

Views: 6434

Answers (2)

Satheesh K
Satheesh K

Reputation: 108

I have an improved version for the answer... use the following code for making the selection in to Indian rupee Symbol with Lakhs crores format, immaterial of your regional settings in Millions format. 

Dim rs As String
rs = ChrW$(&H20B9&)
Selection.NumberFormat = "[>=10000000][$" & rs & "-ta-IN] ##\,##\,##\,##0.00;[>=100000][$" & rs & "-ta-IN] ##\,##\,##0.00;[$" & rs & "-ta-IN] ##,##0.00"

Hope this helps.

Upvotes: -1

GSerg
GSerg

Reputation: 78190

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.

Upvotes: 6

Related Questions