• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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