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 vote364 views1 answer
Vba listbox remove all items
VBA
5 votes409 views1 answer
Vba low byte from INTEGER
VBA
0 vote348 views1 answer
Vbnet line graph smooth lines
VBA
0 vote342 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
3 votes385 views1 answer
Vba post request json
VBA
1 vote369 views1 answer
Vba loop through files in folder
VBA
0 vote341 views1 answer
Excel vba extract year
VBA
11 votes498 views1 answer
Excel vba How to URL encode a string
VBA
0 vote358 views1 answer
Vbnet chart make 0 gridline line different color
VBA
8 votes451 views1 answer
Excel vba make a short integer from two bytes
VBA