How to type Unicode currency character in Visual Basic Editor

0 votes

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:

  • Inserted the symbol in Excel using Insert->Symbol option.
  • Copy pasted the symbol in VBE.

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.

Apr 5, 2022 in Database by Edureka
• 13,690 points
1,246 views

1 answer to this question.

0 votes

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&)
answered Apr 5, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
0 answers

How to add Indian Rupee Currency symbol in Google Spreadsheet

I need to add Indian Rupee Currency ...READ MORE

Apr 7, 2022 in Database by Edureka
• 13,690 points
694 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,331 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
1,848 views
0 votes
1 answer

How to install MySQL in windows?

You can download the all in one ...READ MORE

answered Feb 28, 2019 in Database by Priyaj
• 58,020 points
1,105 views
0 votes
1 answer

How to install MySQL in Ubuntu?

To install MySQL on ubuntu you have ...READ MORE

answered Feb 28, 2019 in Database by Priyaj
• 58,020 points
1,265 views
0 votes
1 answer

How to intsall MongoDB in Windows?

Downloading and Installing MongoDB is the easiest ...READ MORE

answered Mar 1, 2019 in Database by Priyaj
• 58,020 points
797 views
0 votes
1 answer

How to display the queries executed by a particular user in MySQL?

From the version 5.1.7 onward, MySQL allows ...READ MORE

answered Mar 7, 2019 in Database by Mishti
• 480 points
4,431 views
0 votes
2 answers
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
5,258 views
0 votes
1 answer

How to count distinct values in Excel

Use functions to count the number of ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
1,450 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP