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

4 votes277 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote244 views1 answer
Arq linux
VBA
0 vote266 views2 answers
Get unique random number in vb.net
VBA
0 vote229 views1 answer
Add items to combobox vb.net
VBA
0 vote271 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote226 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote241 views1 answer
Excel delete ever other vba
VBA
1 vote228 views1 answer
Vba reverse string
VBA
0 vote251 views1 answer
Excel web scraping
VBA
0 vote219 views1 answer
Remove frist letter from string vbnet
VBA