Make calculated cell visible on User Form

Attached is a portion of my file. At the top of the Pricing Sheet is a button called Add New Tire. When this is open I have highlighted the "textboxes" in yellow and the place where the calculated field goes in light blue. Open Add New Tire and in the yellow cells put any numbers (not big ones) but maybe something like 5, 5, & 5 These numbers per the calculation will equal 22. The problem I have here is that the calculated cell does not appear until I click on the Post Button and then the numbers you entered + the calculated cell will be posted to the Pricing Sheet. The calculated cell appears after you click on the Post Button, but I need to have that calculate cell visible before I post. If I see the results is way off, then maybe I have entered a wrong amount in one of the other 3 cells, so the purpose of this is so that if there is a wrong amount entered then it can be corrected before posting or it will have to be done manually corrected by going to the EOF to (My database has 4500+ rows). Go the VBA and the name of the form is AddTires and look at the code and let me know if you can fix it.

As usual, thanks for the great help i get my you'all and hope the moderator doesn't reject this one.

Jerry

I don't know if you can do this, but if you can open the file in your version of Excel and enter your formula will it work, and if so give me that formula. I don't understand what you mean by restricting the entry to only numbers. I can't use numbers because they haven't been determined yet, because they will change. The formula I have is Weight.Value = 2.47 * Val(SH) * Val(SW) * (Val(SH) + Val(RD)) * 0.036 is the correct answer that goes in the blue cell and I want that to appear in that blue cell before I press the post button. The SH, SW, and RD are the 5, 5, 5 I gave as an example

Btw, my wife's family is from the Netherlands and the last name is Hols

Me again. On the sheet I sent to you I hide about 4 or so sheets. When I open the one I sent to you I can unhide those sheets, but not on the one you returned back to me. In 2019 it says to right click on an active sheet and select unhide, but unhide is greyed out. What I sent you was a my entire program (under a different name, and had deleted about 4500 rows). I copied the deleted rows over to the one I sent you, but the sheets are missing. Is there any way for me to copy or export your code to my copy orginal copy or find your marco? Everything works ok except when all the form is filled in I have to click on another text box to activate the Post Button It doesn't automatically activate.
Button. Thanks, Jerry

Thanks, I added the decimal to the RD value (maybe I forgot to tell you) and commented out the USAGE value because it's not required.

Hartelijk dank, hoop dat ik je op mijn volgende probleem (That' supposed to be: Thank you very much, hope I get you on my next problem)

Never mind on that I just copied your form over to the one I have, so would you be interested in seeing the finals results. I have the form pop upon a sheet where you see how to get the values in the form. I think its neat when a pro-less, non-expert, non Excel guru can do with the help of those who are pro's, experts, and Guru's. I can send you a picture.. Does your private e-mail allow that or a copy of all of it.