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 vote181 views1 answer
Excel delete ever other vba
VBA
0 vote177 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote180 views1 answer
Weekday vba
VBA
2 votes194 views2 answers
Excel vba if sunday or staurday
VBA
0 vote171 views1 answer
Remove last 8 characters from string vb
VBA
0 vote152 views1 answer
How to make a if statement with vbs
VBA
0 vote179 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote173 views1 answer
Excel vba clear filter
VBA
0 vote192 views1 answer
How to make a a msgbpx in vbs
VBA
8 votes285 views1 answer
Excel vba determine number of elements in a 1D array
VBA