textbox value

[ashgull80]

hi
i have a text box in a userform that displays data after calculating data from cells in a sheet.
but after working out the calculation can i set some perimeters for the text box. so it has a ? sign in front of the value, or rounds a decimal number to 2 decimal places?
thanks ash

[Norie]

ash

No you can't, a textbox has no such parameters to set.

What you probably want is the Format function.
[vba]
x = 10

Textbox1.Value = Format(x, "Currency")
[/vba]

[ashgull80]

what is the x = 10 for?

[Bob Phillips]

[vba]

Private Sub TextBox1_AfterUpdate()
With Me.TextBox1

.Value = Format(Replace(Replace(.Value, ",", ""), "?", ""), "?#,##0.00")
End With
End Sub
[/vba]