Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selections fill a form
Hi Guys,
I have a listbox that the user can make any number of selections (multiSelect)then click the cmdSelect button and have it fill another form with labels from the selections. The following code uses the selections but on the form i have to have say 10 labels already set up to be filled and i don't always need 10. I may only need to fill 3 labels with the selections from the list box. Across from the labels i want to have textbox for the user to enter a value. Have any ideas or have i confused everyone. Thank you so much for any help or direction. Private Sub cmdSelect_Click() Dim i As Long Dim SelCount As Long With ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) = True Then SelCount = SelCount + 1 UserForm1.Controls("Label" & SelCount).Caption = .List(i) End If Next End With UserForm1.Show End Sub -- Thank you, Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selections fill a form
You don't need selcount because it is "i + 1" . I believe you can make the
controls visible or not visible. Private Sub cmdSelect_Click() Dim i As Long With ListBox1 For i = 0 To .ListCount - 1 If .Selected(i + 1) = True Then UserForm1.Controls("Label" & (i + 1)).Caption = .List(i) UserForm1.Controls("Label" & (i + 1)).visible = True else UserForm1.Controls("Label" & (i + 1)).visible = False End If Next End With UserForm1.Show End Sub "Jennifer" wrote: Hi Guys, I have a listbox that the user can make any number of selections (multiSelect)then click the cmdSelect button and have it fill another form with labels from the selections. The following code uses the selections but on the form i have to have say 10 labels already set up to be filled and i don't always need 10. I may only need to fill 3 labels with the selections from the list box. Across from the labels i want to have textbox for the user to enter a value. Have any ideas or have i confused everyone. Thank you so much for any help or direction. Private Sub cmdSelect_Click() Dim i As Long Dim SelCount As Long With ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) = True Then SelCount = SelCount + 1 UserForm1.Controls("Label" & SelCount).Caption = .List(i) End If Next End With UserForm1.Show End Sub -- Thank you, Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting cell selections in form spreadsheet | Excel Worksheet Functions | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
Saving User Selections made on a Form | Excel Programming |