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 vote331 views1 answer
Vbnet add axis labels to chart
VBA
2 votes335 views2 answers
Excel vba copy values range to another range
VBA
0 vote360 views1 answer
Open file dialog in vb.net
VBA
4 votes398 views1 answer
VBA Deep Clone Dictionary
VBA
1 vote292 views1 answer
Vba exit do while
VBA
0 vote326 views1 answer
Vba option button selected
VBA
0 vote354 views1 answer
Priavte sub with multiple handels find sneder
VBA
2 votes361 views2 answers
Excel vba if sunday or staurday
VBA
0 vote286 views1 answer
Vba set vs dim
VBA
0 vote333 views1 answer
Vba shape transparent
VBA