![]() |
|
#3
|
|||
|
|||
|
Code:
Private Sub CommandButton1_Click()
Dim bListAll As Boolean
Dim strList As String
Dim lngIndex As Long
'Do you want to list "all" items in the listbox?
bListAll = True
'or do you want to list the item or items selected? Then set the variable above to False
If bListAll Then
For lngIndex = 0 To ListBox1.ListCount - 1
If strList = vbNullString Then
strList = ListBox1.List(lngIndex)
Else
strList = strList & vbCr & ListBox1.List(lngIndex)
End If
Next lngIndex
Else
For lngIndex = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(lngIndex) Then
If strList = vbNullString Then
strList = ListBox1.List(lngIndex)
Else
strList = strList & vbCr & ListBox1.List(lngIndex)
End If
End If
Next lngIndex
End If
ActiveDocument.Range.Text = strList
Hide
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
copy and paste Outlook Email bodytext to Word document
|
eYos | Word VBA | 1 | 08-25-2015 09:41 PM |
| How can I let my users copy and paste into a protected Word Document? | moden9999 | Word | 4 | 02-02-2015 05:39 PM |
Moving Selected Items from a Multiselect Listbox on a userform to a bookmark in Word
|
marksm33 | Word VBA | 3 | 01-15-2015 07:55 PM |
Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word
|
marksm33 | Word VBA | 3 | 01-15-2015 05:59 PM |
| copy from web and paste in a word document : no images are shown | Ron Wolpa | Word | 5 | 09-11-2013 02:16 AM |