VBA For Beginners: Learn Macro Security & Automated Sorting In Excel
HTML-код
- Опубликовано: 8 июл 2024
- 😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_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 video, I'm going to show you how to use some of the powerful features of Microsoft Excel VBA to automate tasks and protect your data. We'll start by learning how to set up macro security, and then we'll move on to the more complex topic of automated sorting. By the end of this video, you'll be able to use VBA to tackle almost any task in Excel, safely and effectively!
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/VBASorting_WkbkDl
🤑 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 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_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
1:29 - Overview
2:36 - Macro Security
4:07 - VBA Editor Options
5:22 - Test Macro
12:21 - Sort Names
22:57 - Insert Shape
25:07 - Selection Change Event
25:43 - Change Event Worksheet
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!
Thank you very much for your continued support,
Randy Austin
#vba #excelvba #Vbaforbeginners #Excelforfreelancers #ExcelSorting #sorting
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
I need platform for properties
Can i buy from you please. No time to learn. I have property
Thats the course i wanted you to create. Without VBA, learing your others tutorial was really difficult. Thanks
I'm glad to hear that this course is what you were looking for! VBA can definitely make a big difference in understanding the other tutorials. Thank you for your feedback!
Hi my friend, even my english is not the better i find your trainings very clear. Thank you from Paris
Thank you so very much, I really appreciate that
please continue this (vba for beginners), thank you so much!
Thanks so much. Yes for sure I will and I have so much to share. Thanks so much. :)
Auto Syntax Check tip is really helpful...
I didn't realize you could still have the formatting differentiation without the dialog box/MsgBox prompt.
Thanks Ben. It took me a while to learn this. That pop-up was getting annoying. I am happy that even experienced developers like you are still able to gain value from these basic training videos. Thank you for your Likes, Shares & Comments. It really helps.
The course is great. With consistency in your new release of VBA for beginners. I believe someday I will get to intermediate level.
For sure you will Emmanuel, and thanks so much for your continued support.
Always find your tutor very clear and pleasing. Thank you.
Thank you so very much, I really appreciate that
No excuse between these Shorts and the Tuesday videos for anyone not to be able to start creating and automating spreadsheets.
Awesome and thanks so much Larry. With these weekend series and the Tuesday series I am trying to provide the foundational learning anyone can use to build their own applications. Thank you for your many years of support.
I cannot stop thanking you for these awesome tutorials. From what I've learned, I have been able to create a macro to auto sort a multiple column sheet. I was wondering if there is a way to delay the sort action until I have entered all the data in the row - perhaps on hitting return?
Hi and thanks. On a change event, that event can check to make sure all of the data has been entered before it is sorted. If there are any missing fields, it would not be sorted.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I learn a lot from this quick VBA topic. Thank you so much. :)
Great, thanks so much. I am happy to help and share.
This video is absolutely useful. Thankful to you, Randy!
Great and thanks so much. I am glad I can help and share
Hi Randy, great video like always, I enjoy so much all your videos, in special vba for beginners.
Great, thanks so much. I am happy to help and share
Thanks again. i will practice this two more times when I knock off. Really intrigued.
For sure, you are very welcome and I am happy to help and share
Randy, excellent as usual!
It is a very good iniciative.
Great and thanks so much Carlos. I am glad you are enjoying the new series
Thank You, Sir. Following you from Ottawa, Canada!
Great, thanks so much Roland. So nice to have you here. Thank you for your Likes, Shares & Comments. It really helps.
Thanks Randy for this amazing video.
Thank you so very much, I really appreciate that Syed. I am glad you like these trainings
I learn lots of VBA from you.
Great Max, I am happy to hear that and thank so much
Thanks a lot Randy, Its Indeed Video for me. Lots of Love from India.
That is great to hear and thanks so much for your continued support.
hey Randy, pleasure as always watching your videos and learn from them,
truelly amazing!
i wold like to see videos about debuging issues, such as (a common one) 1004 etc.
thanks a lot!
Thanks very much. Yes, its a great idea to dedicate a lesson on error handling. I do have an older one that may help here: ruclips.net/video/ZhxWT2vylIE/видео.html
I hope this helps and thanks so much.
thank you for your videos that you have been given to us on this page.. im very excited. thank you once again👍. continue with your good works...
Great Joseph, thanks so much for your continued support. I really appreciate that.
Thank you very much for the videos. Very easy to comprehend and lots of helpful knowledge.
For sure, you are very welcome. I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much, Randy, I learned a lot.
I had purchased courses to help me understand coding, you do it so much better.
I am going to save this 🎉
That is great to hear and thanks so much. I am really glad you liked it and thanks for your support.
I'm also a big fan of your videos, easy to understand and I've been using some of your examples in my Excel applications, not for sale but just for the fun of it in our archery society. Did asked you for some time ago if you could build something like that because I think your application is incredible nice both to look at and how to use them, they are fast even with much data in them. Great work 🙂
Thank you so very much, I really appreciate that Michael and I am glad I can help and share :)
This is that which i want, thank u for ur delivery, very very helpful for begainner like me,
For sure, you are very welcome and I am happy to help and share.
Hi Randy thanks for sharing
For sure, you are very welcome Tobaye. These trainings may be a bit simple for you, but I am happy to help and share.
thank you master . . .
For sure, you are very welcome and thanks so much
Thanks a lot 👍👍👍👍👍
For sure, you are very welcome and thank you too
Interesting lesson. Security is essential. A test template would be interesting to play with during class. It's just a suggestion.
Hi Ara, thanks so much. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
I'm subscribed. I receive the template via email every week. Today the mail was later than usual. I only received it 2 hours ago. Thanks anyway. See you next Tuesday and Saturday. Nice weekend.
@@ExcelForFreelancers
Hi and thanks Ara, yes thanks so much. The Saturday emails will always be later than the Tuesday emails. That is our new schedule, since i want to make sure the email goes out after the video is out. I hope this helps and thanks so much.
Thank you sir Randy
For sure, you are very welcome Ed. Thank you for your continued support.
Just Perfect
Great, thanks so much. I appreciate that
Hello Randy,
I am a great fan of your video's and certainly of the way you're explaining them in detail.
So I have a request for you.
Is it possible (maybe at the end of this course) or in another separate project/video
to show and explain how to create a VBA CLASS Module.
I see it a lot and it seem handy to create own objects with own properties, methods and functions.
Hope you will take my request into consideration and think about it.
Thank you.
Keep on the great and very excellent work.
HI and thanks so much. For sure we will be covering Class Modules within the series in the near future. Thank you for your Likes, Shares & Comments. It really helps.
thanks Randy
For sure, you are very welcome Angel, and happy to help and share
Excellent
Thank you so very much, I really appreciate that
another detail for the newbies; the auto indent for me only appears when i click tab on my keyboard. and yes when the option is set to 10 then one tab click will give you 10 spaces.
Excellent and thanks for sharing. Very helpful indeed. Thank you for your Likes, Shares & Comments. It really helps.
Awesome videos. I'm just learning VBA code. I'm an enthusiastic and I use what I learn on my own apps for my business. What if you need to change several columns before it sorts automatically without clicking a button?
Hi and thanks very much. What you can do is run an advanced filter in which you copy the results to another location on the sheet. In the results of the advanced filter, you can then have the columns in any order you want. I hope this helps and thanks so much.
Thankssss
For sure, you are very welcome Ed. I am happy to help and share. I am really glad you enjoyed the training.
very very helpfull
Excellent! Thanks so much for your support and comment. I really appreciate that
This is amazing sir. Would be good if you can number the series like VBA For Beginners: Lesson 1,2,3
HI and thanks so much. I would like to do that but I can't. If i did that, people would not necessarily watch part 2 of they have not seen part 1.
However I do have a full playlist, in order, here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
I hope this helps and thanks so much.
@@ExcelForFreelancers excellent. Good idea 👍
Great
Thank you so very much, I really appreciate that
Good
Thank you so very much, I really appreciate that and I am glad I can help
thank you for this randy, can you make an advanced search box with first litters of first or second word instead of data validation , so i can search and add to invoice.
Hi and thanks very much. This can be done in a userform. You can find that training here: ruclips.net/video/MFmdIQ2QBf0/видео.html
I hope this helps and thanks so much.
That was very nice tutorial, What if the case is when i delete any cell values in column E it will automatically sorted?
Is that possible? How to do that?
Hi and thanks. yes through VBA certainly. I cover that in most of my videos, in which i delete a record then resort the list. So you would just have to put this sort code within the delete record macro.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks for the reply ❤️
Heck yeah I need bite sized teaching to practice and learn VBA.
Great and thanks so much. This series should help then and I am glad I could help. Thank you for your Likes, Shares & Comments. It really helps.
thanks for this Randy, I am taking the course with Dan. I just have one question/concern that many other followers may have so I thought I would post it here. I hope you or someone can get to answer it. so the Q is: How can I market and sell applications using spreadsheets with Macros such as VBA? because every time someone opens a spreadsheet with macros in it there is a big warning saying do not trust etc., malicious people can imbed codes to attack you etc.. So how can a developer make these applications and not have everyone worried that when that allow macros all their info is going to be stolen? I hope this is a useful question as I see the benefits of VBA macros and you have inspired me to delve into this
HI and thanks very much for your question. Its a great question. Those who use Excel will, unfortunately, have to get used to unblocking macros after downloading. When i sell my Excel-based applications. people are just ok with it since when they purchase it I write in the welcome email that they will have to unblock macros with an automated sentence like this
"Hi and thanks. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much."
Next up I have a Mentorship program that shows you how to define, design, develop and deploy your Excel-based applications for passive income here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Also my next course, in which I will start creating next month will be "How To Lock, License, & Launch Your Excel-Based Application Or Add-in" which will teach you everything you need to know how how to help secure and sell your applications.
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks very much for the in-depth and quick answer. It has helped a lot and I am looking forward to moving on with Excel applications. Kind regards, Sii.
That is great to hear. Thank you for your Likes, Shares & Comments. It really helps.
Hi! Is it possible to sort 1column(column B) while the other columns beside column B either left or right will follow?
Hi and thanks yes you can use a sort command. In the Apply Range you would just expand the range o include the other columns
@@ExcelForFreelancers thanks it works.
At 21:54 why did you declare variable for"LastRow=SortSht.Range("99999)End(xlup).Row"
I am confused so please tell me.
Yes sure. When we are sorting a range. We know the starting row, but we don't know the last row to sort. So we need to determine the last row of data that will be sorted. So we will us a variable for that using the LastRow=SortSht.Range("99999)End(xlup).Row
This will help us determine what that last row is. We then use this variable within our sort line of code. This way when the data grows or shrinks, we do not need to make any changes in our macro. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you soo much
Help! Randy, I am having a problem with the macro in your 2nd lesson. I had no problems with the macro in your first lesson. My problem is I can't get beyond the first line of the macro. I copied your macro for Sheet1 and for the entire first line of the macro, the range, order, ascending and the header. I believe I typed it accurately, but when I go to run the macro it's giving me a compile error and says Syntax error. I do not have Excel365. I tried to type and retype the macro line but I get the same result. I would appreciate any insights you might have. Here is what I typed:
I figured it out!! I never gave a space between Sort and Key. I always had it as SortKey together. Thanks anyway. I 'm really enjoying your lessons. Looking forward to your future lessons!
Very good and I am glad you got it figured out. I am going to try to move very, very slow doing these weekend trainings, since think a basic, foundational VBA trainings are really important. Thanks so much for your valuable feedback.
Using VBA to Sort Only One column (Column Is K with 6 line of Header) I want to sort from K7 to K2502 ascending, help....
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 Thanks very much for your support, I have figured it myself, here's how,
Private Sub CommandButton1_Click()
Range("K6:K2507").Sort Key1:=Range("K6"), _
Order1:=xlAscending, _
Header:=xlYes
With two switches for ascend n Descend
Thanks again Master you were great
Ok very good I am glad you were able to get it figured out. Well done and thanks for the follow up
Do you offer customised excel services?
HI and thanks for your comment. Unfortunately, I am not available for one on one work however, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
What is VBA and y to use it
Hi and thanks so much. I cover the 'What' and 'Why' in this training: ruclips.net/video/RUiRBUeaW4g/видео.html
I hope this helps and thanks so much.
if you please, Mr. show us Hidden Episode
Hi and thanks for your comment. What is 'HIdden Episode'?
Thank you for your Likes, Shares & Comments. It really helps.
Sub TestMacro()
Dim LastRow As Long
LastRow = Sheet1.Range("A1").Value
Sheet1.Range("A1").Value
MsgBox LastRow
End Sub
anyone got the compiler error ?
HI and thanks for your comment.
This line would not be correct or is not needed and you can remove it
Sheet1.Range("A1").Value
I hope this helps and thanks so much.
i m prez. of Rotary Club i have greetings task to perform on Birthday, Spouse Birthday n Anniverssaries on every members on their respective events i want to schedule once wishes msg automatically trigger @ 00:00:00 hrs i have standard msg for Birthday n anniverssary i have created my own mechainismto start whtsapp with vba selenium chrome but i want it to b performed automatically even if my pc is off suggest better solution to achieve task
HI and thanks so much. You will need to use a Wake on LAN feature and make sure your computer is sleeping, but not off, then you can set a specific schedule to run Excel and then user a recurring and automated schedule with my WhatsApp training here: ruclips.net/video/ScUBSfEqcrY/видео.html
I hope this helps and thanks so much.
HI and thanks. I have now completed the Web Automation with Selenium and you can find it here: ruclips.net/video/6IXN1Umu_MU/видео.html
I hope this helps and thanks so much.
Sir i wanted to as that who is "Fred Fredders" 😁
Fred is one of my best partners and he is with me on every training. I just can' work without him :D :D
How I install excel for free
HI and thanks. Excel is a paid application that must be purchased. I hope this helps and thanks so much.
Hi I am looking to make a room manager where we can drag and drop specific clinics fro the hospital I work in. am/pm and evening sessions this will be mostly the same week on week but with a few variations any advice would be appreciated, 🙂
Hi Alex, Thank you for your comment. This would be a custom job. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.