VBA Data Entry Form to find first empty row in a specific range

Hello community,
I need your help again
I have a data entry form which finds the first empty row to enter any data.
In my Excel file, if I enter a number in TextBox1 it goes to Cell A2, enter a number in TextBox2 it goes to Cell B2, enter a number in TextBox3 it goes to Cell C2
Everything works so far, but I would like now to add a fomula in Cell D2, the problem is when I use the form, the number don't go to row 2 anymore, because Cell D2 has the formula. I would like to have the numbers in row 2 to be inserted with the form even if there is formula in D2.
I have attached my file, maybe you can see what I mean.
Thanks in advance for any help you can offer.

Golden rule.
Do not clutter your sheet with on-sheet formula when using VBA.
Do the work within the code.

Please Login or Register  to view this content.

Hi Filipe, thank you so much. This works for me. Amazing. Reps on the way.

Thank you torachan, this also works. :-)