VBA: Syntax Part 1 - The Sentence Structure

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

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

  • @johannesmp3
    @johannesmp3 7 หลายเดือนก่อน +1

    Amazing explanation. Never thought of it that way. Just learned VB. Maybe I should have looked at this 1st

  • @hardeepcharak
    @hardeepcharak 3 ปีที่แล้ว +5

    I really appreciate your time and effort. The people who have arrived at this video means they have the skills to dig deep into roots instead of cramming the stuff like many does.

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

    this is what i was looking for a long time

  • @estherm.duartemunoz7339
    @estherm.duartemunoz7339 ปีที่แล้ว +1

    Best explanation ever!

  • @jarrodstewart8367
    @jarrodstewart8367 5 ปีที่แล้ว +2

    Awesome introduction! Really helped clear up some of my conceptual struggles with vba. Thanks a bunch!

  • @Shgggao_
    @Shgggao_ 5 ปีที่แล้ว +2

    Thank you so much!!! I have been looking for a video like this to give beginners a general idea about how to start the Excel VBA!!!! That's very helpful! Hope you can make more videos!

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

    Thanks, after associate-level programming classes didn't cover the object-oriented paradigm, I have struggled for years (out of college, motivated by curiosity) to see through the mist that surrounded the subject.
    I found your video as I dive into VBA in an effort to make a primitive delivery/order-tracking database for work purposes... Your simple explanation of VBA syntax helped me finally see the object-oriented forest through the trees that have thus far obscured it. I'm making some assumptions here, but thanks.

    • @JadyGrudd
      @JadyGrudd 6 ปีที่แล้ว

      And yeah, I mixed my metaphors.

    • @amberofiesh7966
      @amberofiesh7966  6 ปีที่แล้ว

      I get what you mean, and I'm so happy to have helped you make the leap forward in object oriented programming! When this clicked for me it was a great moment as well.

  • @nirinadonaldherijaona2168
    @nirinadonaldherijaona2168 5 ปีที่แล้ว

    I love the approach of teaching!!!

  • @dbf5803
    @dbf5803 4 ปีที่แล้ว +3

    In the description of the House, You have MEMBERS of the house, with 'Rooms(plural)' - the Collection, at the top, followed by the individual rooms.
    Does the logic follow through then, and under 'Members of Room', instead of just 'Door' and 'Window'... should there be a 'Doors' collection and a 'Windows' collection as well? Especially since there are 3 windows. Thanks for clarifying!

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

      Yes, after rewatching this video I realize I didn't take every opportunity to re-emphasize the extent to which collections exist. any time there's opportunity to have more than one repeating sub-object (all of the same type, like the windows example) that assigns itself to another object, essentially it becomes a collection.
      so in this analogy
      houses
      rooms
      windows
      windowpanes
      doors
      etc.
      are all potential examples of a collection.

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

      @@amberofiesh7966 Thanks! Really do appreciate the clarification.

  • @arvindkumarauro9731
    @arvindkumarauro9731 3 ปีที่แล้ว

    Nicely explain... It's very helpful to understand the concept 👍

  • @peter-e2q
    @peter-e2q 4 ปีที่แล้ว

    Excellent analogy!!! All fits now.

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

    Very good thanks

  • @paranaueuk
    @paranaueuk 5 ปีที่แล้ว

    Kudos Amber, cool analogy.

  • @ALVINIUM1
    @ALVINIUM1 4 ปีที่แล้ว

    Thanks!

  • @ezzat2384
    @ezzat2384 6 ปีที่แล้ว

    Thanks alot it really helped!

  • @finalexam993
    @finalexam993 4 ปีที่แล้ว

    very informative

  • @aftabalamshaikh4515
    @aftabalamshaikh4515 6 ปีที่แล้ว

    thank u ...very helpful