How not to show zero in textboxes?

  • Thread starter Thread starter John Smith
  • Start date Start date
J

John Smith

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
Access Dateadd function question.. 0
Copy value of textbox to clipboard for use in another application 5
Userform Textbox to Worksheet Textbox 1
Firing Event in another user form 1
userform textbox returns changeable date 4
textbox Do nothing 1
Textbox form to Textbox in worksheet 4

Back
Top