How to Master VBA loops FAST (with real coding examples)

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ม.ค. 2025

ความคิดเห็น • 29

  • @Excelmacromastery
    @Excelmacromastery  6 หลายเดือนก่อน

    FLASH SALE: 25% off my Effective Excel VBA course before Saturday 14th September: 👉courses.excelmacromastery.com/courses/Effective_Excel_VBA
    Learn how to write real-world Excel VBA code: 👉courses.excelmacromastery.com/

  • @clintg3435
    @clintg3435 ปีที่แล้ว

    I am great at deciphering others code and tweaking to suit my needs, I couldn't write a loop to save my life. Looking forward to this tutorial. Thanks

  • @vincenttrichy
    @vincenttrichy ปีที่แล้ว +1

    Excellent and simple way explain. Post more advance vba like Update and changed in google sheet using excel vba.

  • @vincentlee7995
    @vincentlee7995 ปีที่แล้ว +1

    Great video. Thank you Paul!

  • @bredmond812
    @bredmond812 ปีที่แล้ว +1

    I learned about the Do Loop because I wanted to exit the loop early under some conditions. It's done with Exit Do. The While loop doesn't have anything like that to break the loop.

  • @ousmanetall1286
    @ousmanetall1286 ปีที่แล้ว +1

    Thank heaps paul. Can you please put online nested dictionary tuto, i have tried it well based on your videos on dictionary, but want to improve it at the best

  • @hammeedabdo.82
    @hammeedabdo.82 ปีที่แล้ว

    Please, Mr. Paul, we would like you to go into depth on the concepts of object-oriented programming in VBA with applied projects.

  • @satyabanukil779
    @satyabanukil779 หลายเดือนก่อน

    How to do it in MS Access form level. Doesn't make sense to beginners until form level demonstration is not shown

  • @jameswilliams5045
    @jameswilliams5045 ปีที่แล้ว

    Nice Opinion :) Personally only ever used For or Do until.

  • @EmmaMyler
    @EmmaMyler 9 หลายเดือนก่อน

    Hello, so i have a lot of pdf urls to download, probably like 1000. How can i download the bulk all at once? like i wanna put all 1000 url in sheet & click 1 button to download it all, is that possible? since do it manually would take ages. Also the i need to login (username & password) first so i can have access to the pdf urls, can u help? thanks so much!

  • @rajchaurasia9322
    @rajchaurasia9322 2 หลายเดือนก่อน

    Hey I've a doubt can you help me?

  • @vijaysahal4556
    @vijaysahal4556 ปีที่แล้ว

    Great sir ❤

  • @vijaysahal4556
    @vijaysahal4556 ปีที่แล้ว

    Very useful information about looo tq sir 😊

  • @flameofthephoenix8395
    @flameofthephoenix8395 11 หลายเดือนก่อน

    I got tired of loops, so I ended up switching to GoTo statements which are much easier to use and understand without all that finicky syntax.

  • @kukuhwahyurinaldi6288
    @kukuhwahyurinaldi6288 ปีที่แล้ว

    Thanks Suhu🙏🙏

  • @tracywang1
    @tracywang1 4 หลายเดือนก่อน

    Nice

  • @BassamThebian
    @BassamThebian 11 หลายเดือนก่อน

    that was great thank you, however am its giving me error 400 once using do while in this code: "Do while sheet2.cells(R,4)"" "". where is the error in this. will very much appreciate your feedback.

  • @Matt-zp9jg
    @Matt-zp9jg ปีที่แล้ว

    Hi very off topic question, do you know how some accounting softwares have vba developed that can create reports and export data to excel. My question is how do they do that? Where do I begin to learn how to do this? Thanks.

  • @AntoinetteSusie-r3m
    @AntoinetteSusie-r3m 3 หลายเดือนก่อน

    White David Lopez Laura Robinson Mary

  • @curtisnell1303
    @curtisnell1303 2 หลายเดือนก่อน

    this is terrible, just full of ads and doesnt show any actual coding

  • @TP-om8of
    @TP-om8of ปีที่แล้ว

    Don’t loop, vectorise!

  • @johnwayne8059
    @johnwayne8059 ปีที่แล้ว +1

    Hi Paul, as usual, again a great video from your side!😊 Thanks a lot for your work!🦾😉