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 vote217 views1 answer
Excel vba arrondir
VBA
0 vote249 views1 answer
Excel vba calculate
VBA
2 votes245 views1 answer
Excel vba check if string entirely numeric
VBA
5 votes249 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
3 votes248 views2 answers
Excel "vba" match last value
VBA
0 vote231 views1 answer
Vba type variable
VBA
3 votes247 views1 answer
Excel insert blank row for value change in column
VBA
0 vote238 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote251 views1 answer
Excel vba join variant array
VBA
0 vote222 views1 answer
Vb.net round to 2 decimal places
VBA