How to input formula in a cell with VBA if the formula returns string?

Hi all, I have the following formula:

=IFERROR(IF(AND(VLOOKUP([@[Country]],LookUpTable,2)="EU",VLOOKUP([@Nationality],LookUpTable,2)="EU"),"EU","Non EU"),"")

Which returns EU or Non EU to my cell based on country (of residence) and nationality, for a survey, and I'm trying to make up a template to enter the data to, (with a userform) and this would be a "calculated" field so I wouldn't get macro errors if the country or nationality is missing for some data rows, and so if we add them later, it would "calculate" it on its own.

So I thought I can write in my code, simply something like:

Please Login or Register  to view this content.

to add the formula into my columns in the template (after the userform input all the data to the row, this is a new column EU / Non EU) to reduce manual inputs as much as possible, but VB gets confused by the double quote marks..

Is this possible through VBA or not?

you need to encase your strings within double quotes

Please Login or Register  to view this content.

AHH awesome double double quotes it is!! Thank you!