Textbox blank if zero

[asyamonique]

If TextBox7.Value = 0 Then TextBox7.Value = ""

Hello,
I have plenty of textboxes on my userform.
If the textbox value is zero I want to make it zero as in sample above.
Is it possible to make it with a code for all the textboxes?
Thanks.

 

[My Aswer Is This]

Try this:

Private Sub CommandButton3_Click()
 'Modified  3/28/2019  11:34:36 PM  EDT
 For Each xcontrol In Me.Controls
            If TypeName(xcontrol) = "TextBox" Then
                If xcontrol.Value = "0" Then xcontrol.Value = ""
            End If
            
        Next xcontrol
End Sub

 

[asyamonique]

Sorry for wrong typing.
I want to keep the textboxes blank if their values are zero.
Thanks

 

[asyamonique]

Thanks for the help,

 

[My Aswer Is This]

Thats exactly what my script does.

Sorry for wrong typing.
I want to keep the textboxes blank if their values are zero.
Thanks

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks for the help,