Excel 2021 VBA Intermediate Tutorial

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 29

  • @МихаилЛюбимцев-п4ь

    Hi! Great job!
    But some common VBA mistake at 15:10. If you declare like this: "Dim Var1, Var2, Var3 As String", only the last variable Var3 will have a String type. The others will be a Variant! You could execute Debug.Print TypeName(Var1) to make sure of it.
    You should declare like: "Dim Var1 As String, Var2 As String, Var3 As String".

  • @wonsilla
    @wonsilla 11 месяцев назад +2

    Great pace and presentation of topics!

  • @LearnitTraining
    @LearnitTraining  Год назад +1

    Exercise Files: learnitanytime.com/p/exercise-files-excel-2021-vba-intermediate-tutorial

  • @analuizanb
    @analuizanb Год назад

    @59:43 some things are unclear. Is variable LastCell supposed to be a range of cells, or one cell only? The instructor contradicted herself.

  • @anshulagarwal7783
    @anshulagarwal7783 10 месяцев назад +2

    Hi, Can you share the ppt used for the VBA trainings?

  • @RB-ed7ux
    @RB-ed7ux 6 месяцев назад

    Unfortunately it seems that the video gets lost at 37:38. It refers to a macro-enabled version of the Vehicles file which isn't in the associated file pack (as pointed out by another user). Also the video refers to a column called Status which isn't in the Vehicles spreadsheet and which hasn't yet been created by the tutor. This is a shame as the tutorial was going well till then. Does anyone have a solution to this confusion?

    • @dhanuj8399
      @dhanuj8399 Месяц назад

      U have to first watch beginners video
      There she made a macro enabled version of vehicles

  • @jaredcarbo697
    @jaredcarbo697 Год назад +1

    Not sure if I'm too late to the party, but is there a Power Point that I'm not seeing? I'd love to see the actual deck so I can take notes at my own pace!

  • @ryu9930
    @ryu9930 Год назад +1

    1:41:09 i got an error on here where my Classmarker was read as string but in "If" was read as Integer, so it didn't match the function. Any solution?

    • @ryu9930
      @ryu9930 Год назад +2

      Solved. In Sub GetNewInventory i didn't put VinNumber, only write VinNum. I still curious why in this sub i need to write the whole VinNumber rather than just short it, but the code will not work if i put on VinNum

    • @prisonmike7924
      @prisonmike7924 20 дней назад

      I'm still getting an error, any solution?

  • @rheysarmiento
    @rheysarmiento 8 месяцев назад

    This is great but I don't think the exercise files are accurate esp for the "Vehicles". Can you please update it with the correct file? Thanks.

  • @emmanuelkwekufrimpong109
    @emmanuelkwekufrimpong109 5 месяцев назад

    Please where can I get the slides used for the lessons?

  • @camcombloux8564
    @camcombloux8564 8 месяцев назад

    The vehicles file isn't xlsm, so I can't see the programs you're referring to during half the video 😕

  • @JHaygood-dq1rp
    @JHaygood-dq1rp Год назад +2

    Thank you I appreciate it a lot

  • @hyperhippyhippohopper
    @hyperhippyhippohopper 4 месяца назад +1

    The singular form of 'Parentheses' is 'Parenthesis', not 'Parenthesy'

  • @dineshrajan6965
    @dineshrajan6965 Год назад +1

    Can there be a course made to automate SAP using VBA??????

  • @cool7500
    @cool7500 Год назад +1

    Thanks a lot for your great service. Please teach us about website creation and designing in wordpress.

  • @deveshwargaikwad9300
    @deveshwargaikwad9300 2 месяца назад

    Gr8

  • @SAXENA2904
    @SAXENA2904 Год назад +1

    Hi