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 vote329 views1 answer
Change form background image vb
VBA
0 vote305 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote338 views3 answers
Write to text file vb.net
VBA
0 vote336 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote340 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote352 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote316 views1 answer
Default host vbox address
VBA
0 vote308 views1 answer
Vb streamreader
VBA
0 vote334 views1 answer
Loop through lines in text file vb net
VBA
0 vote325 views1 answer
WGET FTP
VBA