Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one box to another on a user form
Please can someone help. I have a user form with two list boxes on it. One on
the left and one on the right. The LH box has a list of choices and the RH box is empty. I want a user to highlight a choice or choices in the left box and by clicking a button with an arrow on it pointing to the RH box it will populate the RH box with this choice. Having created a list of choices in the RH box I then want to create a space seperated string of these choices. Anyone done something similar before? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one box to another on a user form
Make sure you set your multiselect option to select multiple or extended,
then put this in the buttons click event. For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) End If Next i -- -John Please rate when your question is answered to help us and others know what is helpful. "JLR-Mart" wrote: Please can someone help. I have a user form with two list boxes on it. One on the left and one on the right. The LH box has a list of choices and the RH box is empty. I want a user to highlight a choice or choices in the left box and by clicking a button with an arrow on it pointing to the RH box it will populate the RH box with this choice. Having created a list of choices in the RH box I then want to create a space seperated string of these choices. Anyone done something similar before? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one box to another on a user form
Thanks John, nearly there. If I wanted the selection to 'move' from one box
to the other rather than 'copy' how would that work? So if I've selected it and put it in the box on the RH side it's no longer an option in the LH side? "John Bundy" wrote: Make sure you set your multiselect option to select multiple or extended, then put this in the buttons click event. For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) End If Next i -- -John Please rate when your question is answered to help us and others know what is helpful. "JLR-Mart" wrote: Please can someone help. I have a user form with two list boxes on it. One on the left and one on the right. The LH box has a list of choices and the RH box is empty. I want a user to highlight a choice or choices in the left box and by clicking a button with an arrow on it pointing to the RH box it will populate the RH box with this choice. Having created a list of choices in the RH box I then want to create a space seperated string of these choices. Anyone done something similar before? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one box to another on a user form
For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) ListBox1.RemoveItem i End If Next i hth Keith |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one box to another on a user form
just add the line i have commented
Private Sub CommandButton1_Click() For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) ListBox1.RemoveItem (i) 'add this End If Next i End Sub -- -John Please rate when your question is answered to help us and others know what is helpful. "JLR-Mart" wrote: Thanks John, nearly there. If I wanted the selection to 'move' from one box to the other rather than 'copy' how would that work? So if I've selected it and put it in the box on the RH side it's no longer an option in the LH side? "John Bundy" wrote: Make sure you set your multiselect option to select multiple or extended, then put this in the buttons click event. For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) End If Next i -- -John Please rate when your question is answered to help us and others know what is helpful. "JLR-Mart" wrote: Please can someone help. I have a user form with two list boxes on it. One on the left and one on the right. The LH box has a list of choices and the RH box is empty. I want a user to highlight a choice or choices in the left box and by clicking a button with an arrow on it pointing to the RH box it will populate the RH box with this choice. Having created a list of choices in the RH box I then want to create a space seperated string of these choices. Anyone done something similar before? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one box to another on a user form
Thanks for the responses...much appreciated
"John Bundy" wrote: just add the line i have commented Private Sub CommandButton1_Click() For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) ListBox1.RemoveItem (i) 'add this End If Next i End Sub -- -John Please rate when your question is answered to help us and others know what is helpful. "JLR-Mart" wrote: Thanks John, nearly there. If I wanted the selection to 'move' from one box to the other rather than 'copy' how would that work? So if I've selected it and put it in the box on the RH side it's no longer an option in the LH side? "John Bundy" wrote: Make sure you set your multiselect option to select multiple or extended, then put this in the buttons click event. For i = 0 To ListBox1.ListCount - 1 On Error Resume Next If ListBox1.Selected(i) = True Then ListBox2.AddItem ListBox1.List(i) End If Next i -- -John Please rate when your question is answered to help us and others know what is helpful. "JLR-Mart" wrote: Please can someone help. I have a user form with two list boxes on it. One on the left and one on the right. The LH box has a list of choices and the RH box is empty. I want a user to highlight a choice or choices in the left box and by clicking a button with an arrow on it pointing to the RH box it will populate the RH box with this choice. Having created a list of choices in the RH box I then want to create a space seperated string of these choices. Anyone done something similar before? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use VBA to copy User Form from 1 workbook to another? | Excel Programming | |||
Copy or Print from User Form? | Excel Programming | |||
USER FORM COPY | Excel Programming | |||
copy sheets selected on user form | Excel Programming | |||
copy sheets selected on user form | Excel Programming |