Syntax rules

[yaniv20]

Hey

I have a problem with where to write anything
Basically, there are sheets, modules and class
And it seems to me that I did not abide by the rules of the language

Variables and Functions I have defined as public, I cannot access them from modules or sheets.

I need to understand the rules, where to write the code in a way that I can access any variable or function without getting involved.

I tried to search the web but my English is not high level
What I need is just a brief general explanation of the subject

Thanks in advance

[Kaper]

It is very vague question.

But if English is not your strong side you could look for some courses in your native language.

These could be on-line courses, or "traditional" or may be books (but with a book it's not so easy to ask a teacher/author )

Check your local universities if they don't run VBA programming courses for their students. During pandemic time many of them are given on-line and there is a chance you could join one of them or at least have the access to course materials.

[Andy Pope]

As a quick guide.

Code Module to store variables and functions that can be accessed from other modules/sheets/classes.

Classes require the generation of object of that class before you can access the variables and function that are public within the class.
Sheet objects are also classes, which Excel initiate for us. So again you would need to include the object in order to get to the objects.

Code Module

Please Login or Register  to view this content.

Class module for Class1

Please Login or Register  to view this content.

Sheet1 code module

Please Login or Register  to view this content.