UserForm Calculation
 

I have values entered into txt1 & txt2 & want to have the respective txt box
(1 or 2)recalculate a new value into txt3 with the formula (txt1*(1-txt2))
when the value in txt1 or txt2 changes. I want all 3 text boxes to display
in percent format with 1 decimal.

I then want this txt3 value to load into a worksheet cell & then have that
same cell value reappear back into txt3 (in percent format with 1 decimal)
everytime I show the UserForm.

UserForm Calculation
 

Sure, no problemo. Which part of this do you need help with ?

Best wishes Harald

"Kro" skrev i melding
...
I have values entered into txt1 & txt2 & want to have the respective txt
box
(1 or 2)recalculate a new value into txt3 with the formula (txt1*(1-txt2))
when the value in txt1 or txt2 changes. I want all 3 text boxes to
display
in percent format with 1 decimal.

I then want this txt3 value to load into a worksheet cell & then have that
same cell value reappear back into txt3 (in percent format with 1 decimal)
everytime I show the UserForm.

UserForm Calculation
 

Both- one at a time!

"Kro" wrote:

I have values entered into txt1 & txt2 & want to have the respective txt box
(1 or 2)recalculate a new value into txt3 with the formula (txt1*(1-txt2))
when the value in txt1 or txt2 changes. I want all 3 text boxes to display
in percent format with 1 decimal.

I then want this txt3 value to load into a worksheet cell & then have that
same cell value reappear back into txt3 (in percent format with 1 decimal)
everytime I show the UserForm.