Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I've got a UserForm with TextBoxes that when opened fill the TextBoxes with numerical values form specific worksheet cells. If the Range value has a number like 4.67, this shows up in the textbox no problem, but when the range value is 4.00 it appears as 4. I would like the textboxes show a minimum of two decimal places. Any assistance would be greatly appreciated. Private Sub UserForm_Initialize() TextBox1.Value = Range("C7").Value TextBox2.Value = Range("C8").Value TextBox3.Value = Range("C9").Value TextBox4.Value = Range("C10").Value End Sub Best regards, Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Decimal Places | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
add 2 decimal places | Excel Discussion (Misc queries) | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |