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

1 vote140 views1 answer
Vba format string as cash
VBA
0 vote134 views1 answer
Rotate image by any angle vb.net
VBA
0 vote129 views1 answer
VB Error Code BC30201
VBA
0 vote86 views10 answers
Vba excel create event log
VBA
0 vote172 views1 answer
Vba excel parser xml
VBA
0 vote125 views1 answer
Vba createparameter null
VBA
0 vote138 views1 answer
Dlete rows with blanks and space " " vba
VBA
1 vote150 views1 answer
Extract the second word in a text in excel
VBA
0 vote144 views1 answer
Excel vba named range exists
VBA
1 vote135 views1 answer
Vbs run
VBA