Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a listbox, the rowsource is a range on a worksheet.
When this listbox is brought up and names picked, I would like to have these names entered starting on A4, going downward. The names are always first and last name, maybe I can extract and copy, but not sure how to do this. Any ideas? TIA Gerry Private Sub OKButton_Click() msg = "" For i = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(i) Then msg = msg & ListBox1.List(i) & vbCrLf Next i MsgBox "You selected: " & msg & vbCrLf Unload Me With Worksheets("PrintJob").Range("A4") .Value = msg .WrapText = True End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to drag items within listbox | Excel Discussion (Misc queries) | |||
listing unmatched items! | Excel Worksheet Functions | |||
Listing all items only once | Excel Discussion (Misc queries) | |||
Counting items in a listbox | Excel Programming | |||
Checking Listbox Items | Excel Programming |