As always a great tutorial. Thank you. One thought, it might be good to have the data searchable. If someone is looking for a specific record or group of records.
Hi and thanks so much. I am glad you like that. I have added a filter data, and by column on the Patreon update here: www.patreon.com/posts/sort-listbox-107231604 I have also added a lot of other features as well on the update. Thank you for your Likes, Shares & Comments. It really helps.
I always pick up on something useful with every video. Even his Saturday videos. I'll see something new even if I'd been doing it for years! They make me think more about the "little" things that make my code run faster and smoother. Randy IS the Excel guru!
Hi and thanks very much James. In the Listbox settings there is an option called 'Column Heads' make sure this is set to true and also the Column Count set to the # of columns you have. This will automatically display the row above your data. I have a VBA Basic training on that here: ua-cam.com/video/YTaZQ9i79uc/v-deo.html I hope this helps and thanks so much.
Good Tutorial ! But watching it I realized why, many years ago, I abandoned listbox in favour of listview for all my apps! Listview has column click event and in built sort feature however with listview you cannot link to excel range (listbox rowsource property) and each item (row)must be entered in a loop from the source data but it is very fast once the data is in a array plus you can also choose which columns to add! Your example also requires that you effectively have too duplicate your data into another range then sort it which is fine if you only have 99 items (rows) but when it gets to 20,000 or more items thats a lot of data excel has to deal with! I do like the idea of adding the arrows to the header gonna go a try that on a list view now!👍
Thanks so much for the ideas and feedback. I do like listview, however when distributing your application, it requires the end-user to set a reference to the listview control. With that said I will be addressing the ListView control within the Patreon update. Thank you for your Likes, Shares & Comments. It really helps.
That is great. There was a post in our group that asked me about this feature last week. I decided to create a video on it with two ways to sort. I am sure you will love it, as I code it from scratch. Thanks for the many years of support.
Hi and thanks very much. I have not yes researched that. I will check it out and make any and all updates in the Patreon Update next week. I hope this helps and thanks so much. www.patreon.com/ExcelForFreelancers
Hi Randy, I did an advanced filter in my VBA code and added some formulas in the results table. How can I perform .sort on the formulas columns? It is currently not working because I have formulas in the column that I want to sort.
Hi , Thanks for your comment. You should be able to sort columns with formulas without issue. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks. Please remember that 'application.caller' will always debug when you try to run this macro inside the VBA Editor. You must run this macro when clicking on a shape. (because application caller is looking for the name of the shape that called the macro. If you just run it with the play button or F5, then there is no shape that called the macro) I hope this helps and thanks so much.
Hi randy please read all and make a video on that thank you. i have solved so many challenges in vba by myself and some of them from your videos , but i have a problem, i tried so much i got 60 to 70% accuracy but i want 100% The problem is I have 2 userforms Userform1 and userform2 I have a commandbutton1 in Userform2 I want that when i click on that commandbutton1, Userform1 Popup on the exact position of the mouse pointer, even if i move the userform2 to anywhere in the sheet, userform2 Popup on the exact same position of the mouse pointer,,, thanks
I've tried your screen to pixel Window API from your Calendar Add in Also I tried other windows API's for Mouse cursor position, I cannot success thank u I want that method for one of my calendar to popup on mouse cursor with another userform to put date in Textbox
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers hi Randy , I send join request to your Facebook group, but admin decline it, "Use a Genuine Account" Even it's my original account
HHi and thanks and I am not sure why admin declined. Can you please email our group admin here shane@ExcelForFreelancers.com Add your username and details so they can understand the issue and get you added
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
As always a great tutorial. Thank you. One thought, it might be good to have the data searchable. If someone is looking for a specific record or group of records.
Hi and thanks so much. I am glad you like that. I have added a filter data, and by column on the Patreon update here: www.patreon.com/posts/sort-listbox-107231604
I have also added a lot of other features as well on the update.
Thank you for your Likes, Shares & Comments. It really helps.
I always pick up on something useful with every video. Even his Saturday videos. I'll see something new even if I'd been doing it for years! They make me think more about the "little" things that make my code run faster and smoother. Randy IS the Excel guru!
Thank you so very much, I really appreciate that Robert. I am so glad to help and share
Thank you Randy ... Your training is always awesome and forcussing on productivity
Thank you so very much, I really appreciate that Neren
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. Thanks again
Hi Randy, great work. However I have question How did you get the column headings to change to display the column headers when scrolling??? Thanks....
Hi and thanks very much James. In the Listbox settings there is an option called 'Column Heads' make sure this is set to true and also the Column Count set to the # of columns you have. This will automatically display the row above your data.
I have a VBA Basic training on that here: ua-cam.com/video/YTaZQ9i79uc/v-deo.html
I hope this helps and thanks so much.
Good Tutorial ! But watching it I realized why, many years ago, I abandoned listbox in favour of listview for all my apps!
Listview has column click event and in built sort feature however with listview you cannot link to excel range (listbox rowsource property) and each item (row)must be entered in a loop from the source data but it is very fast once the data is in a array plus you can also choose which columns to add!
Your example also requires that you effectively have too duplicate your data into another range then sort it which is fine if you only have 99 items (rows) but when it gets to 20,000 or more items thats a lot of data excel has to deal with!
I do like the idea of adding the arrows to the header gonna go a try that on a list view now!👍
Thanks so much for the ideas and feedback. I do like listview, however when distributing your application, it requires the end-user to set a reference to the listview control. With that said I will be addressing the ListView control within the Patreon update. Thank you for your Likes, Shares & Comments. It really helps.
I think Randy is a mind reader. This is what I am working on. It will definitely be fun.
That is great. There was a post in our group that asked me about this feature last week. I decided to create a video on it with two ways to sort. I am sure you will love it, as I code it from scratch. Thanks for the many years of support.
Another great video!
Have you found a way to have only the Amount column right justified?
Hi and thanks very much. I have not yes researched that. I will check it out and make any and all updates in the Patreon Update next week. I hope this helps and thanks so much. www.patreon.com/ExcelForFreelancers
Hi Randy, I did an advanced filter in my VBA code and added some formulas in the results table. How can I perform .sort on the formulas columns? It is currently not working because I have formulas in the column that I want to sort.
Hi , Thanks for your comment. You should be able to sort columns with formulas without issue. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Another great challenge!
Thanks so much Temyra. This one I will be coding from scratch. Thank you so much for your continued support
I was expecting this!
❤
Great! I am happy to hear that and I am sure you will love it.
Please i need help. I am having debug on Right(application.caller, len(application.caller)-8)
Hi and thanks. Please remember that 'application.caller' will always debug when you try to run this macro inside the VBA Editor. You must run this macro when clicking on a shape. (because application caller is looking for the name of the shape that called the macro. If you just run it with the play button or F5, then there is no shape that called the macro)
I hope this helps and thanks so much.
Hi randy please read all and make a video on that thank you.
i have solved so many challenges in vba by myself and some of them from your videos , but i have a problem, i tried so much i got 60 to 70% accuracy but i want 100%
The problem is
I have 2 userforms
Userform1 and userform2
I have a commandbutton1 in Userform2
I want that when i click on that commandbutton1, Userform1 Popup on the exact position of the mouse pointer, even if i move the userform2 to anywhere in the sheet, userform2 Popup on the exact same position of the mouse pointer,,, thanks
I've tried your screen to pixel Window API from your Calendar Add in
Also I tried other windows API's for Mouse cursor position, I cannot success thank u
I want that method for one of my calendar to popup on mouse cursor with another userform to put date in Textbox
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers hi Randy , I send join request to your Facebook group, but admin decline it, "Use a Genuine Account" Even it's my original account
Account name "Mka Freelancer"
HHi and thanks and I am not sure why admin declined. Can you please email our group admin here shane@ExcelForFreelancers.com
Add your username and details so they can understand the issue and get you added