VBA to enter formula in cell not calculating...showing formula in cell

I have a Userform with the following code (this is just part of my code) to enter formulas into my worksheet.

Everything in my code works except the last formula for some reason...it's just entering it in the cell and it's showing the formula, it's not actually calculating it.

The one that's having an issue is this one below...the last one in the set example...every other line of code is running properly.

What am I missing here?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That didn't work either. Here's a blank workbook. The data is entered using the "Enter New Data" button.

sample.xlsm

Holy moly I knew that should be the case too but I made an assumption without checking. Boy. Thanks!