probably because of the visual interaction and obvious confirmation that 'something happened' -- in reality the if statements are often sourounding large chunks of code with things such as changing a cell. You could replace the msgbox line with range("a1").value = "my value response here", or to be more explicit use the sheet name or sheet number to indicate the worksheet as well.

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.

@@amberofiesh7966 Thanks! Really do appreciate the clarification.

thank you, Steve! I hope to bring more soon.

​@@amberofiesh7966 ❤

Declaring variables forces them to stay in the class that you assigned. If you're passing a variable into a function that requires a specific data type, this can ensure the calculation does not break or produce an undesired result. If I pass in a string surrounded by quotes "1" the program will know I'm working with a string without me explicitly declaring it so. Later if I try to treat it like a number, by not having declared the type, the program will attempt to see if it can turn it into a number for the purpose of executing the code I asked it to write example: "1" + 1 = 2 if not declared, it will try to make this work. Alternately, let's say I have something like phone number, or social security number, and I want ONLY numbers, I do not want any string characters, I can explicitly declare it so which will prevent anyone from making an alternate assignment. In this case I can evaluate if something is numeric, produce an 'error' when it's not, and address the problem of fixing the user's entry to I can successfully maintain the data integrity of the element (ie. phone number or social security number without dashes or special characters). There's a lot that happens with declaring or forcing types onto your data that happens much more naturally in databases, but is a little 'loose' in the VBA environment.

Hang tight! More content coming soon :) I just got a new job so I have been busy with the transition, but I will have time to make more videos in the coming days.

Congratulation !!! Best wishes for new job . But miss u !

And yeah, I mixed my metaphors.

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.

I'm so happy to hear it helped! :)

you can find the workbook on my webpage! go to thatsobasic.com

You can find all the files that go with videos on my website thatsobasic.com/intro/