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

5 votes179 views1 answer
Excel vba get user selected range
VBA
0 vote164 views1 answer
Thread sleep vb
VBA
0 vote159 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote180 views1 answer
Vba cell all borders
VBA
0 vote165 views1 answer
Excel vba open browser
VBA
3 votes142 views1 answer
Vba not equal
VBA
0 vote212 views1 answer
Excel vba add reference programmatically
VBA
5 votes168 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote98 views1 answer
Vba select file in folder
VBA
3 votes153 views1 answer
Vba request json
VBA