Copy workbook differences to the worksheet : TextBox « Forms « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Forms
  3. TextBox

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








Related examples in the same category

1.Set the selection in a TextBox
2.Read input from TextBox and assign the value to ActiveCell
3.Add TextBox and format it