Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Using quotation marks

Using quotation marks

ResolvedVersion 2003

Tue 9 Dec 2008, 15:39 Delegate 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:00 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Using quotation marks

Using quotation marks

RE: Using quotation marks

Access articles

Access tip:

Run with the total