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 vote166 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote196 views1 answer
Vb ternary
VBA
0 vote164 views1 answer
Vbnet check if number is even or odd
VBA
1 vote191 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote171 views1 answer
Excel vba protect sheet
VBA
0 vote169 views1 answer
Set column width of datagridview vb.net
VBA
0 vote160 views1 answer
Loop through lines in text file vb net
VBA
0 vote170 views1 answer
Excel vba protect worksheet without password
VBA
0 vote153 views1 answer
Vba text to general
VBA
1 vote159 views1 answer
What does vbs stand for
VBA