Excel VBA - ArrayList (Add, Item, Insert and Count Methods)

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 ต.ค. 2024

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

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

    Nice sound that runs on background

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

    Interesting tutorial on array list in VBA, very little has been covered on this topic in VBA especially on you tube. It is less confusing to watch and see in real life application of mscorlib.Arraylist library, rather going through few written explanation on the web, which take a long time to go through.
    Regarding your tutorial on ArrList, I cannot say they are brilliant as they lack thorough explanation followed by the tutorial. It is difficult to comprehend what you are trying to achieve at the beginning of the tutorial and that ever going music on the background, totally misplaced is more of a nuisance the a help. I watched few of your videos, your code could be more intelligible and indented where needed. I think major drawback is lack of explanation and rather few words or sentences given instead. Positive side that there are no tutorials on this topic in VBA, hence we are grateful on contributions of yours as you done great job presenting it to us. Be as it may, thanks for the effort.

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

      Hi!
      Sir, you have written a very interesting comment. Your comment caught my attention, so with your permission I would like to express my opinion by writing a detailed explanation.
      I'm always trying to write some code that's different so that it's useful for people. The most important thing is that I share the codes I wrote in all my videos. I make videos as simple as possible. Of course, since I don't add my voice as the author in the video, I have to add a song to that video, otherwise, no matter how useful the video is, people may find it boring. Videos can be made with special animations, but unfortunately I don't have time for that. I share the code of all the projects I wrote in the video.
      I am very happy that people benefit from these videos, show their gratitude by subscribing to the channel or liking my videos. People sharing my channel who have created a project using my channel makes me extremely motivated to do this work, it gives me an incentive.
      mscorlib is a very useful library. I have shared several videos about ArrayList which is an object of this library.
      MS Excel VBA - Arraylist: th-cam.com/play/PLI1B27DhmDSRf2S-wfMigo2Xc1E2qndiq.html
      I shared such a game in April of this year. I have used Arrayist object there too. It is really very useful.
      Guess the Winner: Create a New Game Using Excel VBA :th-cam.com/video/GFx0BUAP5MA/w-d-xo.html
      There are many different videos on the channel. For example this video (th-cam.com/video/jRgMZCKX3js/w-d-xo.html). One of the most interesting topics in programming is the topic of dynamic objects. I hope this video will catch your attention.
      I am waiting for your opinion about the videos.

  • @MohAboAbdo
    @MohAboAbdo 2 ปีที่แล้ว

    Thank you very much

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

    Hello, can you tell me the reason/s for using that library instead of the MicrosoftExcelObject16.0 lib

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

      Hi!.
      Sir, the mscorlib library contains ready-made and useful objects. Those objects are not available in the library you mentioned. You can do some things yourself using Lbound, UBound, Array and so on, but if you have such a possibility, why bother yourself or waste your time? ) Microsoft provides us with this opportunity, and we use it. Such a simple answer.
      Watch this video to witness how to skillfully use the Arraylist object:
      Guess the Winner: Create a New Game Using Excel VBA - th-cam.com/video/GFx0BUAP5MA/w-d-xo.html
      Each object must be used in its place. Short but useful code for me. You can use it in your projects if you find it suitable

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

    The video is awesome, but I find the background music atrocious and unnecessary. Will I miss any content by muting your videos? I want to make sure I'm not missing any narration. Thanks!

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

      Do not worry. If you don't like the music, you can mute the music
      Thank you so much for the kind words about the video🙏

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

    Not working, Run time error 91