Answered by : fierce-falcon-4yiu93vz3qzs

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 : https://www.mrexcel.com/board/threads/vba-looping-through-textboxes.198909/ | Last Update : Sun, 07 Feb 21