View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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.