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 votes336 views1 answer
Excel vba last row in range
VBA
2 votes364 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
22 votes521 views1 answer
Xlvba check for folder
VBA
0 vote324 views1 answer
Add items to combobox vb.net
VBA
3 votes349 views1 answer
Vba folderexists
VBA
1 vote344 views1 answer
Excel vba close form escape key
VBA
0 vote342 views1 answer
Vba pass named range to function
VBA
0 vote351 views1 answer
Vlookup columns not next to each other
VBA
0 vote359 views1 answer
Vb streamreader
VBA
0 vote367 views1 answer
Vba first cell in range
VBA