[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

How not to show zero in textboxes?

John Smith

12/16/2006 2:52:00 AM

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.
1 Answer

theSquirrel

12/16/2006 5:41:00 AM

0


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 <jsm...@company.com> 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.