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 vote143 views1 answer
Vba DisplayGridlines
VBA
0 vote158 views1 answer
Vba dictionary clear
VBA
0 vote143 views1 answer
Vbnet line graph smooth lines
VBA
0 vote152 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
-1 vote137 views1 answer
Text to speech vb.net
VBA
0 vote140 views1 answer
Excel vba concatenate range
VBA
0 vote145 views1 answer
Vba array of integers
VBA
0 vote156 views1 answer
Create links in msgbox in vb
VBA
0 vote148 views1 answer
Ribbon show/hide
VBA
0 vote184 views1 answer
Vba userform textbox wrap text
VBA