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