答案1
假设您只使用文本字段(而不使用其他对象),此代码应该适合您(但我没有在 Excel 2016 上尝试过):
Sub Search()
Dim shaShape As Shape
For Each shaShape In ActiveSheet.Shapes
If shaShape.DrawingObject.Text Like "*all*" Then '<== specify you're search term
shaShape.Select
Exit For
End If
Next shaShape
End Sub
答案2
答案3
看看这个,我认为它有你想要的东西 https://excel.tips.net/T011281_Finding_Text_in_Text_Boxes.html