Userform with calculated fields

Hi people.

I have some experience with VBA, but am new to userforms and am trying to get in the right direction on something.
Please see attached excel sheet.

There is a simple table with fields that are inserted manually and others that are calculated.
I would like to have that table converted into a userform where the user would input the values and the calculations would be automatic.

The cells in green are the manual/variable values.
The others are the results I want.

I created a userform in VBA and inserted it in the file as a jpg so you can see what I am looking for.

1 example of the code for 1 calculated field and how I need to do it would be awesome

Thanks in advance

What calculations do you want to do?

What textboxes contain the values involved in the calculations?

When do you want calculation to happen?

Why didn't you include the userform in the example workbook?

If you do web search for something like Excel vba userform tutorial calculations, you will find several step-by-step guides and videos with examples.

Thanks for the help.

@ Norie - the manual values are in cells G2,G3,G6,G7,G9. The cells in green.

The others are the calculations I need and are on the remaining cells of column G.

I want the calculations to occur when all whe values in G2,G3,G6,G7,G9 are inserted manually in the corresponding textboxes
(I just realized that the textbox for price per hour/Machine is missing, so that would have to be added to the userform.

Edit: The calculations could also occur when I click a command button.

I´m inserting the sheet with the userform as suggested with what I have done so far.
Hopefully this will be more clear show what I am looking for.

So right now, I have on cell H5 the calculated Value of 222,2 through a simple devision by another value found through a Vlookup.

If you open the userform

By inserting the values "200" in the textbox1 "perímetro"
By inserting the Values "50" in the textbox2 "Espessura"
And then click on the "calculate" Button, I want the result 222,2 to be displayed in Textbox4 - "Tempo de corte"

I need more calculations but if I could get this one on the right track I could then make my way through to finish the rest of them.
I am having trouble finding the propper way to write this.

Thanks

Try this...

Please Login or Register  to view this content.

Keep in mind a textbox is not like a cell. Textboxes contain Text even when it is numeric text. Which means you may have to convert the numeric-text to a number when the code reads the textbox, or format a number as text when it writes a number to the textbox.

Thanks AlphaFrog that´s awesome! Works like a charm.

Now I´ll try to make sense of the code and incorporate the remaining calculations.

Thanks for the help.

You're welcome.