Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

How do you represent Rightwards Arrow in VBA

I'm trying to write a Macro that will search out the rightwards arrow character in Excel and remove it, but I can't figure out how to represent that character in VB Editor. How can I represent it?

0
ThePATMAN26
Asked:
ThePATMAN26
1 Solution
 
sdwalkerCommented:
The arrows are unicode.  A large solid right arrow is unicode 25B6, while a small one is 25B8.

To refer to the arrow, use ChrW(25B6) etc.

Find out exactly which arrow you have by going here.
http://www.fileformat.info/info/unicode/char/25b8/index.htm
or here
http://unicode.org/cldr/utility/character.jsp?a=25B6

You can use AscW(n) to get the unicode of a character, where n is some character.

Good luck,

sdwalker
0
 
patrickabCommented:
In the use of Onkey the right arrow is given as {RIGHT}
0
 
Wayne Taylor (webtubbs)Commented:
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now