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

2 votes195 views1 answer
Vba uppercase first letter of each word
VBA
5 votes155 views1 answer
Vba array worksheet.index
VBA
12 votes262 views1 answer
Excel vba write string to text file
VBA
0 vote229 views1 answer
Vba count all row
VBA
0 vote199 views1 answer
Compare dates vb
VBA
0 vote218 views1 answer
Date as number vb
VBA
0 vote198 views1 answer
Excel vba current folder
VBA
4 votes193 views1 answer
Excel vba how to reset usedrange
VBA
22 votes276 views1 answer
Excelvba check for directory
VBA
3 votes215 views1 answer
Vba double quote
VBA