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 votes184 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote181 views1 answer
Excel vba hide gridlines
VBA
0 vote174 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote199 views1 answer
Move bindingnavigator vb
VBA
0 vote187 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote188 views1 answer
Vba copy file
VBA
8 votes239 views1 answer
Excel vba make word
VBA
0 vote198 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote181 views1 answer
Excel vba remove formatting from cell
VBA
0 vote185 views1 answer
Excel vba center userform
VBA