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 vote227 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote204 views1 answer
Excel vba cell on change
VBA
0 vote205 views1 answer
Vb streamreader
VBA
0 vote232 views1 answer
Vba vbcrlf chr
VBA
3 votes217 views1 answer
Excel insert blank row for value change in column
VBA
6 votes224 views1 answer
Excel vba isalpha
VBA
0 vote218 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote247 views1 answer
Excel vba paste all to each sheet in workbook
VBA
1 vote210 views2 answers
Vba string length
VBA
0 vote224 views1 answer
Columns dont autoresize on program start vb.net
VBA