Darren
08-25-2007, 01:02 PM
Hi Captains
I have the following questions so get a cup of coffee .... only joking :rotlaugh:
I have the following formula on a spread sheet
=100%-I28/E33
If i use it in a userform with TextBoxes as follows
Private Sub TextBox25_AfterUpdate()
TextBox25 = Format(TextBox25, "#,##0.00")
TextBox26 = Format(TextBox25 * 14 / 100 + TextBox25, "#,##0.00")
TextBox27 = Format(TextBox26 - TextBox25, "#,##0.00")
TextBox29 = Format(100% - TextBox24 / TextBox26, "0.00%")
End Sub
On the userform;
It removes the percentage sign and gives a percentage value in the 9000
or what is the correct procedure to do this calculation.
The other question is i have 5 calculators in the same workbook as userform's namely and they must open in this order and hide the active sheet in the background. In each Calculator i will place a command Button this button must open the next Calculator.
1) BasicTerms with button to
2)OverHeads with a button to
3)TheBasicFormulas with a button to
4) SalesTaxcalc with a button to
5)PromoCalc from the PromoCal a list of at the bottom of the userform where a user can choose a calculator of choice.
The Greatest of thanks go to Malcolm and XLD for there input in this exercise with them this would not have been possible and on completion i will post it for others to view and use,
Kindest regards
Darren
South Africa
ps... Xld you have enough points to fly for a month:beerchug:
I have the following questions so get a cup of coffee .... only joking :rotlaugh:
I have the following formula on a spread sheet
=100%-I28/E33
If i use it in a userform with TextBoxes as follows
Private Sub TextBox25_AfterUpdate()
TextBox25 = Format(TextBox25, "#,##0.00")
TextBox26 = Format(TextBox25 * 14 / 100 + TextBox25, "#,##0.00")
TextBox27 = Format(TextBox26 - TextBox25, "#,##0.00")
TextBox29 = Format(100% - TextBox24 / TextBox26, "0.00%")
End Sub
On the userform;
It removes the percentage sign and gives a percentage value in the 9000
or what is the correct procedure to do this calculation.
The other question is i have 5 calculators in the same workbook as userform's namely and they must open in this order and hide the active sheet in the background. In each Calculator i will place a command Button this button must open the next Calculator.
1) BasicTerms with button to
2)OverHeads with a button to
3)TheBasicFormulas with a button to
4) SalesTaxcalc with a button to
5)PromoCalc from the PromoCal a list of at the bottom of the userform where a user can choose a calculator of choice.
The Greatest of thanks go to Malcolm and XLD for there input in this exercise with them this would not have been possible and on completion i will post it for others to view and use,
Kindest regards
Darren
South Africa
ps... Xld you have enough points to fly for a month:beerchug: