<div>
Private Sub Form_Load() 
&nbsp; &nbsp; Clipboard.Clear 
For i = 1 To 3 
&nbsp; &nbsp; ListView1.ListItems.Add , , &quot;test&quot; 
&nbsp; &nbsp; ListView1.ListItems.Item(i).SubItems(1) = &quot;test1&quot; &amp;&nbsp;i 
&nbsp; &nbsp; ListView1.ListItems.Item(i).SubItems(2) = &quot;test2&quot; &amp;&nbsp;i 
Next i 
&nbsp; &nbsp; 
&nbsp; &nbsp; Dim BUFFER 
&nbsp; &nbsp; For i = 1 To ListView1.ListItems.Count 
&nbsp; &nbsp; &nbsp; &nbsp; BUFFER = BUFFER &amp;&nbsp;ListView1.ListItems.Item(i).Text &amp;&nbsp;vbTab &amp;&nbsp;ListView1.ListItems.Item(i).SubItems(1) &amp;&nbsp;vbTab &amp;&nbsp;ListView1.ListItems.Item(i).SubItems(2) &amp;&nbsp;vbCrLf 
&nbsp; &nbsp; Next i 
&nbsp; &nbsp; &nbsp; &nbsp; Clipboard.SetText BUFFER 
End Sub 

</div>

Private Sub Form_Load()
    Clipboard.Clear
For i = 1 To 3
    ListView1.ListItems.Add , , "test"
    ListView1.ListItems.Item(i).SubItems(1) = "test1" & i
    ListView1.ListItems.Item(i).SubItems(2) = "test2" & i
Next i
   
    Dim BUFFER
    For i = 1 To ListView1.ListItems.Count
        BUFFER = BUFFER & ListView1.ListItems.Item(i).Text & vbTab & ListView1.ListItems.Item(i).SubItems(1) & vbTab & ListView1.ListItems.Item(i).SubItems(2) & vbCrLf
    Next i
        Clipboard.SetText BUFFER
End Sub


<div>
<div class="content wysiwyg-content">
I want to be able to copy selected rows &nbsp;or columns out a listview to the clipboard then be able to paste the resuts into excel and have the data inserted in the colums so it is formatted &nbsp;the same way 
 
so if the listview is like this 
data 1 | &nbsp;data2 &nbsp;| data 3 
row2a | &nbsp;data2 &nbsp;| data 3 
&nbsp; 
I want to be able to highlight those 2 rows in the listview and copy them &nbsp;then paste them into excel or whatever and have them formatted in the rows and colums that were in the listview. 
 
Is there an easy way to do this? 
 
Kelly 
 
 
 

</div>
</div>

I want to be able to copy selected rows  or columns out a listview to the clipboard then be able to paste the resuts into excel and have the data inserted in the colums so it is formatted  the same way 

so if the listview is like this
data 1 |  data2  | data 3
row2a |  data2  | data 3
 
I want to be able to highlight those 2 rows in the listview and copy them  then paste them into excel or whatever and have them formatted in the rows and colums that were in the listview.

Is there an easy way to do this?

Kelly 





Copy data out of a listview

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.