Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Tim,
Here is something of the top of my head. It may not be perfext, but it will get you started... The name of my list box is "lstListBox". Sub PostListBoxEntries() Dim i as Integer For i = 0 to lstListBox.Listcount - 1 ActiveCell.Offset(i,0).Value = lstListBox.List(i) Next End Sub List box entries are addressed by index; the first being index 0. Listcount returns the number of entries in the list, which is one greater than the greatest index, hence the "- 1" in the loop. Hope this works for you. Dale "TimO" wrote: Hello All, I have created a userform where the user makes inputs into a text box that populates a list box. There can be multiple inputs into the list box. My question is.....once I have multiple inputs into the list box, how do I recognize each individual entry and transfer them to my excel sheet? I can populate the listbox, but I am stuck after that. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |