Hi,
I tried to populate selected range from worksheet to listbox.
But notice that the whole thing gone wrong....
Private Sub CommandButton1_Click()
ListBox1.Value = Worksheets("Sheet1").Range("C:D;H:J;L;U:X;AI;AL:AM")
End Sub
I would like to have only the red range to be in the list box.
can some one help me with this?
really appreciate your help.
regards
VJ
I think you don't need a CommandButton click event to populate the ListBox.
Why not populate the ListBox with UserForm initialize event?
Place the below code into the UserForm Module.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thank you very much sir.... that's very nice.
Just wondering why I only can see 6 items on the list box ? I have set 12 items.
regards
VJ
I didn't scroll to the right on the sheet and missed those columns.
Replace the existing code with the following one.
The red colored numbers in the code are the column indexes which are to be populated in the ListBox.
Please Login or Register to view this content.
Excel.gif
done sir ... but cant see all when I play.
To view those columns in the ListBox, you will need to set the ColumnCount property to 13.
To do so, open the UserForm in design mode, select the ListBox and press F4 to open properties and locate ColumnCount and change it to 13. The existing ColumnCount is set to 6 so you can only view 6 columns in the Listbox.
Here is the file for your reference.
wonderful sir.... thanks you very much.
how you did it?
regards
VJ
You're welcome VJ!
As I told you that you were required to set the ColumnCount property for the ListBox to view all the columns.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks