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

22 votes461 views1 answer
Xl vba check for folder
VBA
0 vote288 views1 answer
WGET FTP
VBA
3 votes276 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
5 votes295 views1 answer
Xl vba double quotes in string literal
VBA
1 vote275 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote301 views1 answer
Columns dont autoresize on program start vb.net
VBA
3 votes277 views1 answer
Vba make long from two shorts
VBA
0 vote276 views1 answer
Vba word open document read only
VBA
2 votes272 views1 answer
Excel vba extract file name
VBA
0 vote282 views1 answer
Excel vba show developer tab
VBA