B
bach
Hi,
After some searching on the forum I found a article which was what
was looking for.
WHAT AM I DOIN
I have a sheet with data on it, I want to populate a list box with dat
displayed on this sheet.
CODE CURRENTLY USIN
Code
-------------------
Dim ws As Worksheet
Set ws = Worksheets("Member_list")
With ws
Me.lstMembers.List = Application.Transpose(.Range(.Range("A2"), .Range("A2").End(xlDown)).Value)
End With
-------------------
PROBLEM
- The list box populates with every row in the worksheet. I want th
list box to populate with only the data on the sheet so I guess
need to do a check on available data first any idears ???
- The listbox is only using the first colum A2 but since I don
really understand the code I not sure what to change. Could someon
explain and give possible solutions
Kind Regard
After some searching on the forum I found a article which was what
was looking for.
WHAT AM I DOIN
I have a sheet with data on it, I want to populate a list box with dat
displayed on this sheet.
CODE CURRENTLY USIN
Code
-------------------
Dim ws As Worksheet
Set ws = Worksheets("Member_list")
With ws
Me.lstMembers.List = Application.Transpose(.Range(.Range("A2"), .Range("A2").End(xlDown)).Value)
End With
-------------------
PROBLEM
- The list box populates with every row in the worksheet. I want th
list box to populate with only the data on the sheet so I guess
need to do a check on available data first any idears ???
- The listbox is only using the first colum A2 but since I don
really understand the code I not sure what to change. Could someon
explain and give possible solutions
Kind Regard