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

3 votes231 views1 answer
Excel vba change format of cell
VBA
1 vote215 views1 answer
Vba optional
VBA
0 vote221 views1 answer
Vba DisplayGridlines
VBA
7 votes212 views1 answer
Vba array declaration
VBA
0 vote214 views1 answer
Vba file size
VBA
0 vote230 views1 answer
Vba is integer
VBA
0 vote229 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote215 views1 answer
Vb check if row has column
VBA
0 vote240 views1 answer
Vba character ascii code
VBA
0 vote229 views1 answer
Excel vba delete folder
VBA