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 vote153 views1 answer
Openfiledialog specific folder
VBA
0 vote150 views1 answer
Vba string
VBA
0 vote150 views2 answers
Get excel file from email attachment in vba
VBA
0 vote162 views1 answer
Vba find sub dictionary
VBA
1 vote157 views1 answer
Excel vba get column number from column name
VBA
5 votes174 views1 answer
Excel-vba get integer high byte
VBA
1 vote148 views1 answer
Excel vba hide zero values
VBA
0 vote161 views1 answer
Move bindingnavigator vb
VBA
0 vote160 views1 answer
Excel vba hide gridlines
VBA
0 vote168 views1 answer
Power query M substract minimum value of column -dax
VBA