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 vote219 views2 answers
Excel vba copy paste after last row
VBA
0 vote216 views1 answer
Vba copy paste value only
VBA
0 vote225 views1 answer
Excel vba disable keyboard input
VBA
1 vote232 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
3 votes237 views1 answer
Extract the nth word from a text string
VBA
0 vote219 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote244 views1 answer
Excel vba convert cells address
VBA
0 vote252 views1 answer
Sendkeys vba selenium
VBA
0 vote254 views1 answer
Vba verticalalignment
VBA
0 vote238 views1 answer
Supprimer la valeur de celule vba
VBA