在EXCEL中先把第一格输入2个'',然后再复制这一格,粘他50行,就变成了注释前面的字符"'" 然后再把代码粘到EXCEL第二列,再全选粘加VB就OK了Private Sub Form_Load() Dim s s = Clipboard.GetText MsgBox "a" Dim s2 s2 = Clipboard.GetText MsgBox s = s2 End Sub ' Private Sub Form_Load() ' Dim s ' s = Clipboard.GetText ' MsgBox "a" ' Dim s2 ' s2 = Clipboard.GetText ' MsgBox s = s2 ' End Sub
这个直接做个小软件替换一下也可以 Private Sub Form_Load() Dim S As String 'S = Clipboard.GetText S=TEXT1.TEXT S = VB代码行变注释(S)Clipboard.Clear Clipboard.SetText S MsgBox S End SubFunction VB代码行变注释(S As String) As String VB代码行变注释 = "'--暂不用的代码 " & Replace(S, vbCrLf, vbCrLf & "'--暂不用的代码 ") End Function
然后再把代码粘到EXCEL第二列,再全选粘加VB就OK了Private Sub Form_Load()
Dim s
s = Clipboard.GetText
MsgBox "a"
Dim s2
s2 = Clipboard.GetText
MsgBox s = s2
End Sub
' Private Sub Form_Load()
' Dim s
' s = Clipboard.GetText
' MsgBox "a"
' Dim s2
' s2 = Clipboard.GetText
' MsgBox s = s2
' End Sub
Private Sub Form_Load()
Dim S As String
'S = Clipboard.GetText
S=TEXT1.TEXT
S = VB代码行变注释(S)Clipboard.Clear
Clipboard.SetText S
MsgBox S
End SubFunction VB代码行变注释(S As String) As String
VB代码行变注释 = "'--暂不用的代码 " & Replace(S, vbCrLf, vbCrLf & "'--暂不用的代码 ")
End Function