Excel ListBox Data Sorting Made Simple & Coded From Scratch
HTML-код
- Опубликовано: 23 июл 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN RUclips MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this training from scratch, I share with you two unique methods on how to sort ListBox data both ascending and descending. 1) with a single click on any column header and 2) Simply selecting on a header to sort from a combo box.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
www.excelforfreelancers.com/S...
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
0:33 - Overview
3:56 - Designing Main Sheet
6:04 - Sort Data
13:47 - Sort Order
25:53 - Initialize Userform
30:27 - Change Sort By Column
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#vba #excelvba #Sorting #ListboxData #SortListBoxes #SortListBoxData #SortDataInListbox
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
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 so much Randy for this amazing video.
For sure, you are very welcome Syed. Thanks again
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.
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.
Thank you Randy ... Your training is always awesome and forcussing on productivity
Thank you so very much, I really appreciate that Neren
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 was expecting this!
❤
Great! I am happy to hear that and I am sure you will love it.
Another great challenge!
Thanks so much Temyra. This one I will be coding from scratch. Thank you so much for your continued 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.
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