Hi Trish, That was an awesome tutorial far beyond scratching the VBA surface . You really master the art of teaching! Thank you for the great work done 👏👏👏!
Lesson 2, Excel Object Model Hierarchy Collections, blew my mind. A 1000 watt light bulb went off for me. I have tried to understand that for a while, and you put it all together in about 5 minutes of video. Bravo!! Thanks!!
Thank you for the video, very informative! 1:48:24 For my application on my Mac an error message appears when I select the worksheet object - 'Variable uses an Automation type not supported in Visual Basic' - would you know what this means or how I can solve the problem?
Am pre comfy about the coding part, but when it comes to the term of describing it, I kinda confused myself, Like what's a procedure, sub-procedure, or module?
In VBA (Visual Basic for Applications), these terms are fundamental to organizing and executing code: Procedure: A procedure is a block of code that performs a specific task. There are two main types of procedures in VBA: Sub Procedure: This type of procedure performs actions but does not return a value. It is defined using the Sub and End Sub statements. For example: Sub ShowMessage() MsgBox "Hello, World!" End Sub Function Procedure: Unlike a Sub procedure, a function returns a value. It is defined using the Function and End Function statements. For example: Function AddNumbers(a As Integer, b As Integer) As Integer AddNumbers = a + b End Function Module: A module is a container for storing procedures and declarations. There are different types of modules: Standard Module: Used to store general procedures and functions that can be accessed from anywhere in the project. Class Module: Used to create objects and define their properties, methods, and events.
Hello Dwarfus! We just tested the link and files and they are all currently working. Please check your computers security settings as they can sometimes block access to our onedrive links.
We just double checked the link and files and they are all currently working. Please click on download in the upper left after clicking the link to download a local copy of the files.
It's wrong to do like this: Dim i, m, k As Long. Because i and m will be Variant, not Long. In VBA you must specify a type for every variable. So correct way is Dim i As Long, m As Long, k As Long. The same for String, Double, Byte and so on
This is an outstanding tutorial. Extremely well-presented in a well-ordered sequence. I'm impressed.
Thank you for the kind words!
Hi Trish, That was an awesome tutorial far beyond scratching the VBA surface . You really master the art of teaching! Thank you for the great work done 👏👏👏!
You are so welcome!
Another awesome course by another awesome trainer. Thank you.🙏👍
Our pleasure!
You're a great teacher, that was awesome..
We appreciate that!
Great video
Glad you enjoyed it!
Thanks for keeping this so simple, even I understand...so far. I haven't finished yet!
You're very welcome!
Hi Trish, so simple lesson. thank you so much. where can i get the slides used in the video.
Lesson 2, Excel Object Model Hierarchy Collections, blew my mind. A 1000 watt light bulb went off for me. I have tried to understand that for a while, and you put it all together in about 5 minutes of video. Bravo!! Thanks!!
Glad it helped!
moi xem 1 cai video la biet lam luon roi thanks ban nhieu lam
Chúng tôi rất vui vì bạn đã học được rất nhiều! Cảm ơn vì đã xem!
Thank you for the video, very informative!
1:48:24 For my application on my Mac an error message appears when I select the worksheet object - 'Variable uses an Automation type not supported in Visual Basic' - would you know what this means or how I can solve the problem?
Hello Kitty Cat! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Am pre comfy about the coding part, but when it comes to the term of describing it, I kinda confused myself, Like what's a procedure, sub-procedure, or module?
In VBA (Visual Basic for Applications), these terms are fundamental to organizing and executing code:
Procedure: A procedure is a block of code that performs a specific task. There are two main types of procedures in VBA:
Sub Procedure: This type of procedure performs actions but does not return a value. It is defined using the Sub and End Sub statements. For example:
Sub ShowMessage()
MsgBox "Hello, World!"
End Sub
Function Procedure: Unlike a Sub procedure, a function returns a value. It is defined using the Function and End Function statements. For example:
Function AddNumbers(a As Integer, b As Integer) As Integer
AddNumbers = a + b
End Function
Module: A module is a container for storing procedures and declarations. There are different types of modules:
Standard Module: Used to store general procedures and functions that can be accessed from anywhere in the project.
Class Module: Used to create objects and define their properties, methods, and events.
@@LearnitTraining That's pre clear, thank you for your time and the detailed response.
Thank you very much, this was clear professional and educational video, it helped me a lot, I am now moving on to the intermediate one 😁
You are very welcome! Thank you for watching!
Great Video, Thanks
You're welcome!
Thank you
You're welcome
The URL for the files in the video description "Cannot be found".
Hello Dwarfus! We just tested the link and files and they are all currently working. Please check your computers security settings as they can sometimes block access to our onedrive links.
Great course
Thank you!
Why is that exercise file not opening ??
We just double checked the link and files and they are all currently working. Please click on download in the upper left after clicking the link to download a local copy of the files.
This was amazing.
Thanks!
GREAT VIDEO
Thank you for the kind words~!
Hi, can you do a video how to send jpg image from excel to Whatsapp. Many thanks
Will try!
It's wrong to do like this: Dim i, m, k As Long. Because i and m will be Variant, not Long. In VBA you must specify a type for every variable. So correct way is Dim i As Long, m As Long, k As Long. The same for String, Double, Byte and so on
Thanks for the tip!
Where can I get the files for this tutorial?
Exercise Files: bit.ly/37mAIZM
Where is slide deck?
Hello Gregory! We do not share the slide decks anymore unfortunately
Hi, where can i download the slides please? Thanks
Hi Njoo! We don't normally include the slide deck with our videos.
O
More stuff from Faz please
Will do!
Faz rulez
Good contant I also make video on similar subject
Subscribed!
01:10:12
👍👍
48:23
PLEASE MAKE THIS COURSE IN HINDI
👍👍
45:55