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 vote123 views1 answer
Vbnet check if number is even or odd
VBA
0 vote116 views1 answer
Excel vba scroll to cell
VBA
0 vote119 views1 answer
Excel vba existence of a file
VBA
6 votes132 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote127 views1 answer
Vba add spaces
VBA
0 vote126 views1 answer
Move bindingnavigator vb
VBA
0 vote125 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote161 views1 answer
Vba excel parser xml
VBA
0 vote129 views1 answer
Show unix time in vba
VBA
0 vote118 views1 answer
Test if form is open vb
VBA