I think you're trying to fit Java and the little bit you know about it into a programming paradigm you know well from your VBA experience, and it's not going to fit.
Classes provide the framework for defining the characteristics, actions, and external interfaces of objects which are instances of the class. Your fundamental concept of what a class is, does, and can be used for is not yet right, and I don't think you're going to get it right in this venue, primarily because we don't have a common language to use to discuss the topic.
If you pick up a modern Java book and work through the first 5 to 7 chapters, which shouldn't take you that long, you should begin to understand OOP, classes, and objects and develop a common language we can then use to share ideas and concepts.
You might also pick and choose topics from the
Oracle Tutorials to read through to help you understand these concepts as well as how Java code does things.