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, 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.
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.
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
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.
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 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
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.
