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 votes136 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote125 views1 answer
How to add line graph vb net
VBA
5 votes131 views2 answers
Excel vba write to the windows registry
VBA
5 votes134 views1 answer
Excel-vba get integer high byte
VBA
0 vote114 views1 answer
Do until vb.net
VBA
0 vote125 views1 answer
Make your computer talk vbscript
VBA
0 vote112 views1 answer
Loop through lines in text file vb net
VBA
2 votes121 views1 answer
Excel vba date to string conversion
VBA
0 vote120 views1 answer
Excel vba first working day month
VBA
0 vote116 views1 answer
Vba get application version
VBA