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

-1 vote205 views1 answer
Vba code to add new column in table
VBA
0 vote226 views1 answer
Weekday vba
VBA
0 vote205 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote217 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
1 vote208 views1 answer
How to put a gridpain in a vbox
VBA
1 vote208 views1 answer
What does vbs stand for
VBA
0 vote220 views1 answer
Excel last used row
VBA
1 vote202 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
1 vote220 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
6 votes230 views1 answer
Excel vba isalpha
VBA