Тёмный

VBA For Beginners: Learn Macro Security & Automated Sorting In Excel 

Excel For Freelancers
Подписаться 531 тыс.
Просмотров 16 тыс.
50% 1

😎 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 RU-vid 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

Опубликовано:

 

2 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 123   
@ExcelForFreelancers
@ExcelForFreelancers 2 месяца назад
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
@mursalalishariif3363
@mursalalishariif3363 12 дней назад
I need platform for properties Can i buy from you please. No time to learn. I have property
@user-uj4el7wn5b
@user-uj4el7wn5b 14 дней назад
Hi Randy, great video like always, I enjoy so much all your videos, in special vba for beginners.
@ExcelForFreelancers
@ExcelForFreelancers 13 дней назад
Great, thanks so much. I am happy to help and share
@fbfb9049
@fbfb9049 5 месяцев назад
Hi my friend, even my english is not the better i find your trainings very clear. Thank you from Paris
@ExcelForFreelancers
@ExcelForFreelancers 5 месяцев назад
Thank you so very much, I really appreciate that
@aliahsan771
@aliahsan771 7 месяцев назад
Thats the course i wanted you to create. Without VBA, learing your others tutorial was really difficult. Thanks
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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!
@akibul_islam
@akibul_islam 7 месяцев назад
please continue this (vba for beginners), thank you so much!
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Thanks so much. Yes for sure I will and I have so much to share. Thanks so much. :)
@fikriasyrafi8121
@fikriasyrafi8121 4 месяца назад
Always find your tutor very clear and pleasing. Thank you.
@ExcelForFreelancers
@ExcelForFreelancers 4 месяца назад
Thank you so very much, I really appreciate that
@emmanuelivwighre5399
@emmanuelivwighre5399 7 месяцев назад
The course is great. With consistency in your new release of VBA for beginners. I believe someday I will get to intermediate level.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure you will Emmanuel, and thanks so much for your continued support.
@trungtuminh
@trungtuminh 7 месяцев назад
This video is absolutely useful. Thankful to you, Randy!
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Great and thanks so much. I am glad I can help and share
@Tornadosigiloso
@Tornadosigiloso 3 месяца назад
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 🎉
@ExcelForFreelancers
@ExcelForFreelancers 3 месяца назад
That is great to hear and thanks so much. I am really glad you liked it and thanks for your support.
@carloscrespo-riera9815
@carloscrespo-riera9815 7 месяцев назад
Randy, excellent as usual! It is a very good iniciative.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Great and thanks so much Carlos. I am glad you are enjoying the new series
@user-kp1dc1fe6h
@user-kp1dc1fe6h 7 месяцев назад
I learn a lot from this quick VBA topic. Thank you so much. :)
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Great, thanks so much. I am happy to help and share.
@BenLinfordUK
@BenLinfordUK 7 месяцев назад
Auto Syntax Check tip is really helpful... I didn't realize you could still have the formatting differentiation without the dialog box/MsgBox prompt.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@MegaTimPim
@MegaTimPim 7 месяцев назад
Thank you very much for the videos. Very easy to comprehend and lots of helpful knowledge.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure, you are very welcome. I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 7 месяцев назад
Thanks Randy for this amazing video.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Thank you so very much, I really appreciate that Syed. I am glad you like these trainings
@connief2679
@connief2679 2 месяца назад
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?
@ExcelForFreelancers
@ExcelForFreelancers 2 месяца назад
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
@baitsepk
@baitsepk 5 месяцев назад
Thanks again. i will practice this two more times when I knock off. Really intrigued.
@ExcelForFreelancers
@ExcelForFreelancers 5 месяцев назад
For sure, you are very welcome and I am happy to help and share
@josephamoako4963
@josephamoako4963 7 месяцев назад
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...
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Great Joseph, thanks so much for your continued support. I really appreciate that.
@invisibleone6267
@invisibleone6267 7 месяцев назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZhxWT2vylIE.html I hope this helps and thanks so much.
@tinytoons2517
@tinytoons2517 Месяц назад
thank you master . . .
@ExcelForFreelancers
@ExcelForFreelancers Месяц назад
For sure, you are very welcome and thanks so much
@maxchung2419
@maxchung2419 Месяц назад
I learn lots of VBA from you.
@ExcelForFreelancers
@ExcelForFreelancers Месяц назад
Great Max, I am happy to hear that and thank so much
@rolandnormiljacques1678
@rolandnormiljacques1678 7 месяцев назад
Thank You, Sir. Following you from Ottawa, Canada!
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Great, thanks so much Roland. So nice to have you here. Thank you for your Likes, Shares & Comments. It really helps.
@michaelsvenson2456
@michaelsvenson2456 7 месяцев назад
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 🙂
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Thank you so very much, I really appreciate that Michael and I am glad I can help and share :)
@mosharrofhossain-nx6nw
@mosharrofhossain-nx6nw 6 месяцев назад
This is that which i want, thank u for ur delivery, very very helpful for begainner like me,
@ExcelForFreelancers
@ExcelForFreelancers 6 месяцев назад
For sure, you are very welcome and I am happy to help and share.
@stmprocess1549
@stmprocess1549 27 дней назад
Just Perfect
@ExcelForFreelancers
@ExcelForFreelancers 27 дней назад
Great, thanks so much. I appreciate that
@vinoliyakitchen2226
@vinoliyakitchen2226 7 месяцев назад
Thanks a lot Randy, Its Indeed Video for me. Lots of Love from India.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
That is great to hear and thanks so much for your continued support.
@tobayekaina8610
@tobayekaina8610 7 месяцев назад
Hi Randy thanks for sharing
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure, you are very welcome Tobaye. These trainings may be a bit simple for you, but I am happy to help and share.
@larryduffie1617
@larryduffie1617 7 месяцев назад
No excuse between these Shorts and the Tuesday videos for anyone not to be able to start creating and automating spreadsheets.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@AngelGonzalez-ce9ki
@AngelGonzalez-ce9ki 7 месяцев назад
thanks Randy
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure, you are very welcome Angel, and happy to help and share
@robbe58
@robbe58 7 месяцев назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@edparaiso9218
@edparaiso9218 7 месяцев назад
Thank you sir Randy
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure, you are very welcome Ed. Thank you for your continued support.
@AraRoodbuik
@AraRoodbuik 7 месяцев назад
Interesting lesson. Security is essential. A test template would be interesting to play with during class. It's just a suggestion.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@AraRoodbuik
@AraRoodbuik 7 месяцев назад
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
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@redhaakhund1271
@redhaakhund1271 7 месяцев назад
Thanks a lot 👍👍👍👍👍
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure, you are very welcome and thank you too
@ishangoinyambo6523
@ishangoinyambo6523 7 месяцев назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Excellent and thanks for sharing. Very helpful indeed. Thank you for your Likes, Shares & Comments. It really helps.
@chechen100pb
@chechen100pb 6 месяцев назад
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?
@ExcelForFreelancers
@ExcelForFreelancers 6 месяцев назад
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.
@learn_tricks_excel
@learn_tricks_excel 3 месяца назад
Excellent
@ExcelForFreelancers
@ExcelForFreelancers 3 месяца назад
Thank you so very much, I really appreciate that
@kralios
@kralios 7 месяцев назад
very very helpfull
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Excellent! Thanks so much for your support and comment. I really appreciate that
@edparaiso9218
@edparaiso9218 7 месяцев назад
Thankssss
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
For sure, you are very welcome Ed. I am happy to help and share. I am really glad you enjoyed the training.
@moayadhboubati3495
@moayadhboubati3495 2 месяца назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 2 месяца назад
Hi and thanks very much. This can be done in a userform. You can find that training here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MFmdIQ2QBf0.html I hope this helps and thanks so much.
@abdiazizibrahim9163
@abdiazizibrahim9163 6 месяцев назад
This is amazing sir. Would be good if you can number the series like VBA For Beginners: Lesson 1,2,3
@ExcelForFreelancers
@ExcelForFreelancers 6 месяцев назад
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 ru-vid.com/group/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
@abdiazizibrahim9163
@abdiazizibrahim9163 6 месяцев назад
@@ExcelForFreelancers excellent. Good idea 👍
@ihabziyad8611
@ihabziyad8611 3 месяца назад
Great
@ExcelForFreelancers
@ExcelForFreelancers 3 месяца назад
Thank you so very much, I really appreciate that
@sat1460
@sat1460 7 месяцев назад
Good
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Thank you so very much, I really appreciate that and I am glad I can help
@Michael--Hubbard
@Michael--Hubbard 7 месяцев назад
Heck yeah I need bite sized teaching to practice and learn VBA.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@jonelatendido9836
@jonelatendido9836 4 месяца назад
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?
@ExcelForFreelancers
@ExcelForFreelancers 4 месяца назад
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.
@jonelatendido9836
@jonelatendido9836 4 месяца назад
@@ExcelForFreelancers Thanks for the reply ❤️
@siibrittan1238
@siibrittan1238 7 месяцев назад
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
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@siibrittan1238
@siibrittan1238 7 месяцев назад
@@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.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
That is great to hear. Thank you for your Likes, Shares & Comments. It really helps.
@user-km7fg6sd8x
@user-km7fg6sd8x 7 месяцев назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@jhorimelhiva5377
@jhorimelhiva5377 3 месяца назад
Hi! Is it possible to sort 1column(column B) while the other columns beside column B either left or right will follow?
@ExcelForFreelancers
@ExcelForFreelancers 3 месяца назад
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
@jhorimelhiva5377
@jhorimelhiva5377 3 месяца назад
@@ExcelForFreelancers thanks it works.
@kalpanathakur6300
@kalpanathakur6300 7 месяцев назад
At 21:54 why did you declare variable for"LastRow=SortSht.Range("99999)End(xlup).Row" I am confused so please tell me.
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@kalpanathakur6300
@kalpanathakur6300 7 месяцев назад
​@@ExcelForFreelancers Thank you soo much
@doctordollarman1856
@doctordollarman1856 6 месяцев назад
Do you offer customised excel services?
@ExcelForFreelancers
@ExcelForFreelancers 6 месяцев назад
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.
@johnboffin476
@johnboffin476 2 месяца назад
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....
@ExcelForFreelancers
@ExcelForFreelancers 2 месяца назад
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.
@johnboffin476
@johnboffin476 2 месяца назад
@@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
@ExcelForFreelancers
@ExcelForFreelancers 2 месяца назад
Ok very good I am glad you were able to get it figured out. Well done and thanks for the follow up
@ishangoinyambo6523
@ishangoinyambo6523 7 месяцев назад
Sub TestMacro() Dim LastRow As Long LastRow = Sheet1.Range("A1").Value Sheet1.Range("A1").Value MsgBox LastRow End Sub anyone got the compiler error ?
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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.
@Thukai-Operater
@Thukai-Operater 7 месяцев назад
What is VBA and y to use it
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
Hi and thanks so much. I cover the 'What' and 'Why' in this training: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RUiRBUeaW4g.html I hope this helps and thanks so much.
@hazemali382
@hazemali382 6 месяцев назад
if you please, Mr. show us Hidden Episode
@ExcelForFreelancers
@ExcelForFreelancers 6 месяцев назад
Hi and thanks for your comment. What is 'HIdden Episode'? Thank you for your Likes, Shares & Comments. It really helps.
@murlidharhasseja6523
@murlidharhasseja6523 7 месяцев назад
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
@ExcelForFreelancers
@ExcelForFreelancers 7 месяцев назад
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ScUBSfEqcrY.html I hope this helps and thanks so much.
@ExcelForFreelancers
@ExcelForFreelancers 2 месяца назад
HI and thanks. I have now completed the Web Automation with Selenium and you can find it here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6IXN1Umu_MU.html I hope this helps and thanks so much.
@AyushmanThakur-mo3ee
@AyushmanThakur-mo3ee 5 месяцев назад
Sir i wanted to as that who is "Fred Fredders" 😁
@ExcelForFreelancers
@ExcelForFreelancers 5 месяцев назад
Fred is one of my best partners and he is with me on every training. I just can' work without him :D :D
@mathmamah1897
@mathmamah1897 4 месяца назад
How I install excel for free
@ExcelForFreelancers
@ExcelForFreelancers 4 месяца назад
HI and thanks. Excel is a paid application that must be purchased. I hope this helps and thanks so much.
@alexdocherty462
@alexdocherty462 5 месяцев назад
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, 🙂
@ExcelForFreelancers
@ExcelForFreelancers 5 месяцев назад
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.
Далее
VBA For Beginners: Mastering Variables Like A Pro
24:30
Whose action is better?🥹 #filaretiki #shorts
01:00
Просмотров 723 тыс.
THE POLICE TAKES ME! feat @PANDAGIRLOFFICIAL #shorts
00:31
Master These Simple Filtering Hacks In Excel VBA Today
23:26
25 Nooby VBA Habits You Need to Ditch Right Now
8:42
Excel Macros & VBA - Tutorial for Beginners
50:20
Просмотров 1,1 млн