Entering specified cell value into a formula within a userform

[Chris S.]

I have a userform that inputs a value from a textbox into column P of the row of the active cell when clicked.
My end goal is to have the userform insert an "if" formula into column G of my worksheet that uses that data inserted in column P as my true statement.
However it's saying expected end of statement where i have underlined and I'm not sure why my logic is failing.
here is my code.

Please Login or Register  to view this content.

Any help on this would be super appreciated!!

[stnkynts]

Can you be more specific on what you are trying to do with the if statement

Please Login or Register  to view this content.

[Chris S.]

Thanks for looking at this Stnkynts, to elaborate for you;

If Column A cell in current row = "Yes" Then
Put value of Column P of current row into Column G of current row
Else Column G of current row should be blank

[stnkynts]

Try:

Please Login or Register  to view this content.

[Chris S.]

Works Perfect, Thanks Stnkynts!