Scribd
Upload
19 views

Vba - Using As A Character in A Statement - Stack Overflow

This document is a question posted on Stack Overflow asking how to use double quotes as a character within a VBA string. The question provides some sample code attempting to loop through cells and search for values within quotes. The top answer explains that you need to use four quotation marks ("") to escape a single quote within a VBA string. The answer also provides a method using a constant to cleanly define the quote character for use within strings. This resolves the issue the question was having with properly including quote characters in VBA strings.

Uploaded by

Amit Satnalika
Copyright
© © All Rights Reserved
Available Formats
Download as PDF, TXT or read online on Scribd
19 views

Vba - Using As A Character in A Statement - Stack Overflow

This document is a question posted on Stack Overflow asking how to use double quotes as a character within a VBA string. The question provides some sample code attempting to loop through cells and search for values within quotes. The top answer explains that you need to use four quotation marks ("") to escape a single quote within a VBA string. The answer also provides a method using a constant to cleanly define the quote character for use within strings. This resolves the issue the question was having with properly including quote characters in VBA strings.

Uploaded by

Amit Satnalika
Copyright
© © All Rights Reserved
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Products Log in Sign up

Ask Question

Using " as a character in a


statement [duplicate]
Asked 4 years, 4 months ago

Modified 4 years, 4 months ago Viewed 335 times

This question already has answers


here:
-1
How do I put double quotes in a string
in vba? (4 answers)

Closed 4 years ago.


1

Hi there I am trying to use " as a


character in my code, but VBA always
auto corrects it as excess characters
(like if I try """ ). I tried to use the
Char(34) character code but it still
doesn't work. I want to loop through
cells and search for values within the
cell such as " ActiveCell.Value " but
the code doesn't recognize " as a
character. Here is the code:

Sub zero()

Do Until IsEmpty(ActiveCell.Value)

Shell ("C:\Program Files (x86)\Google

ActiveCell.Offset(1).Select

Loop

End Sub

vba excel

Share Follow

asked Apr 24, 2018 at 15:32


Rhyfelwr
269 1 5 19

5 You need to double up the quotes to


escape them in VBA, so
doubleQuotes = """" is
assigning one double-quote
character, which is indeed
Chr(34) . "but it doesn't work"
isn't a useful problem description we
can work with. How is it failing?
– Mathieu Guindon Apr 24, 2018 at
15:36

Could you tell us what


Debug.Print "C:\Program
Files
(x86)\Google\Chrome\Applicat
ion\Chrome.exe -url
https://www.google.co.uk/sea
rch?q=" & Chr(34) &
ActiveCell.Value & Chr(34)
returns? – TomJohnRiddle Apr 24,
2018 at 15:37

This code works 100% fine for me.


Are you getting an error, incorrect
results? What's the problem exactly?
– JNevill Apr 24, 2018 at 15:50

Add a comment

Sorted by:
1 Answer
Highest score (default)

You need to use four rabbits ears within


a VBA string for a single quotation
4 character.

For this reason I define

Public Const vbQuote As String = """"

and use in this way

& vbQuote & ActiveCell.Value & vbQuote

Share Follow

answered Apr 24, 2018 at 15:43


Bathsheba
229k 33 352 472

Thank you this method worked, I was


actually asked by a colleague who
doesn't have a SO account to post
this that's why I couldn't define
clearly what the problem was.
– Rhyfelwr Apr 25, 2018 at 8:36

Add a comment

Not the answer you're looking for? Browse other


questions tagged vba excel or ask your own
question.

The Overflow Blog

The many problems with implementing Single


Sign-On

Hackathons and free pizza: All about Stack


Overflow’s new Student Ambassador...

Featured on Meta

Announcing the Stack Overflow Student


Ambassador Program

Google Analytics 4 (GA4) upgrade

The [option] tag is being burninated

Should I explain other people's code-only


answers?

Reviewer overboard! Or a request to improve


the onboarding guidance for new...

Linked

150 How do I put double quotes in a string in vba?

Related

46 How to loop in excel without VBA or macros?

616 How to avoid using Select in Excel VBA

0 VBA If Statement and For Loop moving to the


cell below

1 How to Make Cells "Blank," not "Empty" in VBA

0 If statement with a variable without a loop

Hot Network Questions


If Hans Niemann is cheating, how?

What determines which military uniform is worn at


which event by members of the Royal Family

A Riddle In Between

Do these NY old dumb laws actually exist?

Is there a reasonable "text-to-speech" solution for


math papers?

Lady Penelope's birth date and wikipedia

how to find a file that is NOT executable

ANSI terminal color behaves strangely

Does there exist a second degree curve with exactly


two solutions?

In what manner "prescribed by law" can a soldier be


permitted to stay in a privately owned home without
violating the Third Amendment?

Does "SHA-256/192" use different initial values from


SHA-256?

Which of those parameters is default in DBCC


SHRINKFILE command?

Simplify with given equality

What value is there in requiring students to answer


word problems in complete sentences?

In novel writing, should I change the referred name of


a character when he revealed his name to the
protagonist?

Alternative interpretation of multiple regression


coefficients?

Why do high rated players still take so much time to


calculate a pawn endgame position close to a game
that they (likely) had before?

How to solve this group of equations?

Why are the 767’s main landing gear spaced


considerably farther apart than airplanes of a
comparable size?

How to diplomatically tell coworker to back off?

Can an interviewer ask me why I'm no longer with my


past employer?

Can a person go to the court if she signed a contract


not to go to court?

What is the best way to plan an inland sailing trip?

Pack of dogs - best response to owner?

STACK OVERFLOW

Questions Help

PRODUCTS

Teams Advertising Collectives Talent

COMPANY

About Press Work Here Legal Privacy Policy

Terms of Service Contact Us Cookie Settings

Cookie Policy

STACK EXCHANGE NETWORK

Your privacy
Technology Culture & recreation Life & arts Science

Professional
By clicking “Accept
Businessall cookies”,
API Datayou agree Stack Exchange
can store cookies on your device and disclose information
in accordance with our Cookie Policy.

Blog Facebook Twitter LinkedIn Instagram


Accept all cookies Customize settings
Site design / logo © 2022 Stack Exchange Inc; user contributions
licensed under CC BY-SA. rev 2022.9.13.42973

You might also like