Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto calculation on a userform | Excel Discussion (Misc queries) | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Calculation does not appear in userform | Excel Programming | |||
Calculation does not appear in userform | Excel Programming | |||
Date Calculation in UserForm TextBox | Excel Programming |