How not to show zero in textboxes?
 

I have a userform with several textboxes. I do not want the
textboxes to show zero value. Is there an easy way to do this? Thanks.

How not to show zero in textboxes?
 

You can try this... Not sure if this is what you need


Private Sub TextBox1_Change()
If Me.TextBox1.Value = "0" Then
Me.TextBox1.Value = ""
End If
End Sub


theSquirrel


On Dec 15, 6:52 pm, John Smith wrote:
I have a userform with several textboxes. I do not want the
textboxes to show zero value. Is there an easy way to do this? Thanks.