98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Using quotation marks
Using quotation marks
Resolved · Low Priority · Version 2003
Tue 9 Dec 2008, 15:39Delegate Juho said...
Juho has attended:
Excel VBA Intro Intermediate course
Using quotation marks
Hi,
I would need to add a formula that includes quotation marks from vb into a worksheet.
The formula beeing
=VLOOKUP(TEXT(Interface!K34,"????/????"),Odds!$S$1:$T$81,2)
I've tried it in form:
Sheets(1).Cells(35, 11).Value = "=VLOOKUP(TEXT(Interface!K34,"????/????"),Odds!$S$1:$T$81,2)"
but vb doesn't seem to like quotation marks inside other quotation marks. Is there a way of gettibg around this.
Thans for you help in advance,
Juho
Wed 21 Jan 2009, 15:00Trainer Laura said...
RE: Using quotation marks
Hi Juho
Thank you for your question.
Quotes within a string can be done if you double the quotes.
"=VLOOKUP(TEXT(Interface!K34,""????/????""),Odds!$S$1:$T$81,2)"
Regards
Laura GB
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
