Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code below is doing what I want in incrementing an
interest rate in a text box by an 1/8 of a point. I would like it to always display to 3 decimal places, but it goes: 5.125, 5.25, 5.375, 5.5, dropping trailing zeros. I know it needs a Format. Any help is appreciated. Private Sub UserForm_Activate() txtInterestRate.Value = "5.000" etc. ------------------------------------ Private Sub spnInterestRate_SpinUp() txtInterestRate.Value = txtInterestRate.Value + 0.125 End Sub ------------------------------------- Private Sub spnInterestRate_SpinDown() txtInterestRate.Value = txtInterestRate.Value - 0.125 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform textbox number formats | Excel Discussion (Misc queries) | |||
userform textbox | Excel Worksheet Functions | |||
Textbox number formatting | Excel Programming | |||
formatting text in TextBox in UserForm | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |