marksince1984
New Member
- Joined
- Oct 15, 2006
- Messages
- 3
The code below reads a column from a worksheet (could be any lenght) and uses the values to populate a listbox
Now i want to set a variable for every value in that list so i can use it later on in the package
Ie
List
List Item 1 > Variable1
List Item 2 > Variable2
List Item 3 > Variable3
etc etc
Any ideas??
Code:
Dim lrow As Long
lrow = Sheets("sheetwithlist").Range("BA65336").End(xlUp) .Row
With UserForm1
.ListBox1.RowSource = "BA2:BA" & lrow
End With
'Hide this menu
UserForm1.Hide
'Show Next form
UserForm2.Show
Now i want to set a variable for every value in that list so i can use it later on in the package
Ie
List
List Item 1 > Variable1
List Item 2 > Variable2
List Item 3 > Variable3
etc etc
Any ideas??