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 vote188 views1 answer
Vba random number
VBA
15 votes241 views1 answer
Excel vba wait
VBA
0 vote176 views1 answer
Convert number to minutes in vba
VBA
0 vote171 views2 answers
Vb.net include quotes in string
VBA
0 vote167 views1 answer
Vba shape transparent
VBA
0 vote243 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote176 views1 answer
Vba simple quote
VBA
7 votes171 views1 answer
Vba array declaration
VBA
0 vote148 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote162 views1 answer
Vbscript for loop
VBA