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 vote245 views1 answer
Add text to Shape VBA
VBA
1 vote239 views1 answer
Extract the second word in a text in excel
VBA
0 vote243 views1 answer
Vba get relative cell address
VBA
0 vote246 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote223 views1 answer
Vb window.minimize
VBA
0 vote237 views1 answer
Excel vba remove formatting from cell
VBA
0 vote221 views1 answer
Do until vb.net
VBA
18 votes320 views3 answers
Excel-vba make integer
VBA
2 votes238 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote225 views1 answer
Vba option button selected
VBA