Dear All
I have a multicolumn listbox populated with a data.
So could anyone help me any of these two questions/requests:
1. is there a way I can scroll my listbox items by using mouse?
2. can I sort my listbox items at desired column?
The file is attached
Thnk youin advance
GUURE
Hello
Have a look at this file (may be helpful for you in your case)
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Dear Yasser
Thank you for your reply.
I can not access to this code as this error pops up.
These declarations have to be changed to work on 64 Bit and I don't have 64 Bit now to try changing
Waiting for others to try to edit so as to suit the 64 bit system
I could only sort the sheet depending on the column you select from the combobox.
When you change the combobox, the listbox clears and the sheet is sorted, then the list box is repopulated.
Normally, one cannot Scroll in the listbox
Please Login or Register to view this content.
Last edited by davesexcel; 03-09-2017 at 01:11 PM.
Here's one from Andy Pope to sort by double clicking column in ListBox.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you all Yasser, Daves and Bakerman2
I have got a greathint enought to what I am looking for.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks