it is possible to format a Form TextBox Value?

Hello

I 'm working with VBA Forms and i would like to keep the numbers with just 3 decimals, but i can't find a way to do this with the properties of a Form. Is this possible or I have to handle the number before and after showing it in the textbox window?

Any help appreciated

Thanks

Jose Luis

Hi,

Not sure if this is what you want, but this code will set the textbox to 3 decimals.
When you Tab or press the Enter key the textbox will show 3 decimals.




Private Sub Textbox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) 'tab key
Application.ScreenUpdating = False
If KeyCode = "9" Or KeyCode = "13" Then
If IsNumeric(TextBox1.Value) Then
TextBox1.Value = Format(TextBox1.Value, " #,##0.000")
End If
End If
End Sub

Charles

Thank you so much Charles , that's what i was looking for.


Jose Luis