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 vote292 views1 answer
Vba check 32 or 64 bit
VBA
0 vote316 views1 answer
Vba extract filename from path
VBA
0 vote298 views1 answer
Change form background image vb
VBA
4 votes281 views2 answers
Vba array length
VBA
0 vote306 views1 answer
Excel vba protect worksheet without password
VBA
0 vote319 views1 answer
Move bindingnavigator vb
VBA
0 vote298 views1 answer
Vba horizontalalignment
VBA
0 vote248 views1 answer
How to sort datagridview in vb.net
VBA
0 vote286 views1 answer
Vbnet line graph smooth lines
VBA
0 vote277 views1 answer
Vbs send keys
VBA