Copying Cell Values

  • Thread starter Thread starter sunroyal
  • Start date Start date
S

sunroyal

Is there a way to have a value placed on the clipboard automatically
after the cell is populated?
 
Hi
put the following code in your worksheet módule. It will automatically
put the value of a cell entered in column A on the clipboard

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub
With Target
If .Value <> "" Then
.Copy
End If
End With
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
clipboard 1
flexible find 3
Can the default paste options on the clipboard be changed? 1
Name a worksheet tab based on the value in a cell. 1
Copy/Past from Word-spreadsheet format alignment disregarded 3
how to copy, do something else, THEN paste? 1
Populate cell with a value if another cell has a certain value 5

Back
Top