这是一段word,vba可以执行的代码Dim MyData As DataObject
Private Sub CommandButton1_Click()
TextBox1.SelStart = 0
TextBox1.SelLength = TextBox1.TextLength
TextBox1.Copy MyData.GetFromClipboard
TextBox2.Text = MyData.GetText(1)
End SubPrivate Sub UserForm_Initialize()
Set MyData = New DataObject
TextBox1.Text = "Move this data to the " _
& "Clipboard, to a DataObject, then to " & "TextBox2!"
End Sub但是放到vb里却不能执行, 提示没有TextLength和TextBox1.Copy为什么呢?
Private Sub CommandButton1_Click()
TextBox1.SelStart = 0
TextBox1.SelLength = TextBox1.TextLength
TextBox1.Copy MyData.GetFromClipboard
TextBox2.Text = MyData.GetText(1)
End SubPrivate Sub UserForm_Initialize()
Set MyData = New DataObject
TextBox1.Text = "Move this data to the " _
& "Clipboard, to a DataObject, then to " & "TextBox2!"
End Sub但是放到vb里却不能执行, 提示没有TextLength和TextBox1.Copy为什么呢?
修改为
TextBox1.SelLength = Len(TextBox1.Text)TextBox1.Copy
修改为
ClipBoard.Clear
ClipBoard.SetText TextBox1.SelText