Forms VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Forms
  4. Copy workbook differences to the worksheet
Private Sub cmdCopy_Click()
    Workbooks("Compare WorkBooks.xls").Worksheets("Sheet1").Activate
    Cells.Clear
    Range("A1").Select
    yourTextField.SelStart = 0
    yourTextField.SelLength = Len(txtReferences.Text)
    yourTextField.Copy
    ActiveSheet.Paste
End Sub