Vba loop through textboxes

Dim ws As Worksheet
Dim t
    Set ws = Worksheets(1)
    For Each t In ws.OLEObjects
        If Left(t.Name, 7) = "TextBox" Then
            t.Object.Text = ""
        End If
    Next t

Source: mrexcel.com

Similar codes

0 vote184 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote173 views1 answer
How to use if condition in time vba
VBA
2 votes179 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote176 views1 answer
Vbs write file
VBA
6 votes185 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote189 views1 answer
Visual stuiod not recognising desgined labels
VBA
2 votes170 views1 answer
Date format for ms chart vb.net
VBA
0 vote169 views1 answer
Vbnet get file name from path
VBA
0 vote218 views1 answer
Vba is integer
VBA
5 votes174 views1 answer
Excel vba high word from Long Integer
VBA