UserForm Calculation

[Guest]

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.

 

[Harald Staff]

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

Best wishes Harald

 

[Guest]

Both- one at a time!