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 vote342 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote282 views1 answer
Create new worksheet excel visual basic
VBA
0 vote311 views1 answer
Do while not vb.net
VBA
0 vote316 views1 answer
Excel vba round to whole number
VBA
0 vote303 views1 answer
Label de tableau dans des label.text en VBA
VBA
12 votes428 views1 answer
Excel vba write string to text file
VBA
0 vote319 views1 answer
Change form background image vb
VBA
1 vote322 views2 answers
Vba string length
VBA
4 votes281 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote329 views1 answer
Excel vba urlmon
VBA