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 vote175 views1 answer
How to add line graph vb net
VBA
0 vote166 views1 answer
Compare dates vb
VBA
0 vote169 views1 answer
Vbscript Trim
VBA
-1 vote162 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote189 views1 answer
Vba cell all borders
VBA
0 vote172 views1 answer
String contins in vba
VBA
0 vote168 views1 answer
Vba len variant
VBA
0 vote176 views1 answer
Convert unix to date vba
VBA
11 votes235 views1 answer
Excel vba How to URL encode a string
VBA
0 vote178 views1 answer
Selecttoken em vbnet e json
VBA