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

2 votes288 views1 answer
Excel vba pause
VBA
0 vote341 views1 answer
Vba get relative cell address
VBA
8 votes384 views1 answer
Run command pormpt in background windows
VBA
0 vote322 views1 answer
Vb window.minimize
VBA
1 vote298 views1 answer
Vba exit do while
VBA
0 vote348 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
3 votes313 views1 answer
Excel vba last row in range
VBA
0 vote315 views1 answer
Putting marquee in vb.net
VBA
0 vote335 views1 answer
Vba first cell in range
VBA
0 vote376 views1 answer
Method showalldata of object _worksheet failed vba
VBA