vba loop through textboxes

The solution for “vba loop through textboxes” can be found here. The following code will assist you in solving the problem.

Get the Code! 
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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

vba remove first 2 characters from string vba remove the first character of string

Bym0nxt3r

The solution for “vba remove first 2 characters from string vba remove the first character of string” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]