Learn The 5 Best Practices You Should Be Doing In Excel VBA

āđāļŠāļĢāđŒ
āļāļąāļ‡
  • āđ€āļœāļĒāđāļžāļĢāđˆāđ€āļĄāļ·āđˆāļ­ 4 āļ.āļ„. 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 TH-cam MEMBERS FOR UNRELEASED TRAININGS ▹ rebrand.ly/YTMembership_YTDesc
    In this tutorial I share with you all of the best practices, tips, tricks and techniques to help you write effective and efficient VBA Code to help you write better programs in less time.
    ⮇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
    www.excelforfreelancers.com/V...
    ðŸĪ‘ 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
    3:52 - Add New Customer
    12:21 - Edit Customer
    24:32 - Check Shared Folder
    25:02 - Check And Sync Workbook
    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 #Vbaforbeginners #Excelforfreelancers #VBABestPracticies #VBACourse

āļ„āļ§āļēāļĄāļ„āļīāļ”āđ€āļŦāđ‡āļ™ • 15

  • @joemanflyer2001
    @joemanflyer2001 5 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +2

    Nice Randy. More shortcuts and training!

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      For sure, you are very welcome Joe, thanks again

  • @codhybutterfield3441
    @codhybutterfield3441 4 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +1

    Hey there! Love your videos, they’ve been super helpful. I’m working on a project management app and hitting a snag with loading and saving data across multiple database sheets. For instance, I’ve got a projects sheet and a tasks sheet. The tasks use a ProjectID (like 1 for the project, then 101 for the first task, 102 for the second, and so on). I need to load the main project and its associated tasks all at once. Could you make a video on this or give me some pointers? Thanks!

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      Hi and thanks very much. I do have a series of videos on this with both Projects and Tasks here: th-cam.com/play/PLIBeRriXvKzBgiKcu6UdD9E_4S8xiKUWq.html
      I hope this helps and thanks so much.

  • @hassanjaved5469
    @hassanjaved5469 5 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +2

    Can you make video that cover class module intermediate skills.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      HI and thanks so much. I have a basic Class Module training here: th-cam.com/video/8j8BvTAPNX4/w-d-xo.html
      I hope this helps and thanks so much.

  • @petardzopalic3220
    @petardzopalic3220 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +1

    Dear Randy thank you on yours teachings.
    Can you advise me on this one, in our company we have a server and there is a lot of folders and subfolders on server.
    My chief told me one day that he wants to see who has permission on which folders and subfolders.
    He means who from employees has rights to read, edit, copy etcâ€Ķ
    Can it be done via VBA?
    Thank you in advance.

    • @ExcelForFreelancers
      @ExcelForFreelancers  22 āļŠāļąāđˆāļ§āđ‚āļĄāļ‡āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      HI and thanks for your comment. Yes I believe it is possible using the shell command and icacls however I have not tried any specific code to do this. It would take a bit of research. I hope this helps and thanks so much.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 6 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +1

    Thanks for the share Randy.

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      For sure, you are very welcome Syed. thanks so much for your continued support

  • @khalidmounir3475
    @khalidmounir3475 6 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +1

    Thanks, could u plz do videos about converting xlsm to exe with rights restrictions and without relying on Excel when saving or editing data. Thanks again

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      Hi and thanks so much. While you can convert Excel to exe, when extracting the core file, you will always require Excel to make it function. I hope this helps and thanks so much.

    • @khalidmounir3475
      @khalidmounir3475 5 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +1

      @@ExcelForFreelancers thanks a lot

  • @henkvinck888
    @henkvinck888 6 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē +1

    THNX Randy

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 āļ§āļąāļ™āļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

      For sure, you are very welcome Henk. I am happy to help and share