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

11 votes403 views1 answer
Excel vba How to URL encode a string
VBA
0 vote238 views1 answer
Visual basic cmd
VBA
0 vote215 views1 answer
Excel vba round to whole number
VBA
0 vote179 views1 answer
Excel vba address not absolute
VBA
1 vote198 views1 answer
Set font for ms chart vb.net
VBA
0 vote194 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote193 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote188 views1 answer
Vb test if reference is null
VBA
0 vote187 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote249 views1 answer
Excel vba delete columns in range
VBA