嘿,一些<br>谢谢你,我有点理解你发布的代码,但我尝试了一些更简单的东西,比如:<br><pre>- Dim SearchString As String, SearchChar As String, NewSearchChar As String
- SearchString = "CMB*****L" ' String to search in.
- SearchChar = "L" ' Search for Character
- NewSearchChar = "R" ' Replace with New Character
- For Each Ctrl In Userform1.Controls
- If TypeOf Ctrl Is CommandButton Then
- If InStr(1, SearchString, SearchChar) Then
- Replace(SearchString, SearchChar, NewSearchChar) As String
- End If
- End If
- Next Ctrl
我可以抓取所有命令按钮,如果我只使用Instr功能;它将使用此搜索字符串返回所有命令按钮
但是,我无法使替换功能正常工作。有人能告诉我哪里出错了吗
CM很可能是正确的,因为名称是只读的,但我很好奇这是否有效
谢谢,
马克
|