Excel VBA Classes - Property LET compile error

To fix the problem the property needs to include the boolean

Please Login or Register  to view this content.

You property usage is confusing. You would normal use it to store the username or the online state. You seem to be testing online state and username is just and argument. If this is a userclass object why do you need to pass username?

I would have expected something more like this.

Please Login or Register  to view this content.

with the class code

Please Login or Register  to view this content.

Andy,

Hello. I have thought on it... I guess I don't see any advantage to using 'LET' if you can't execute code the way I desire.

For instance....


CLASS:

Please Login or Register  to view this content.

SUB:

Please Login or Register  to view this content.

So, if I wanted to LET Online Property to TRUE (i.e. do some meaningful work in a database or sheet) then its reasonable to assume, my only option here is to design a method...

Example:


CLASS:

Please Login or Register  to view this content.

OK So now when I write my procedure in my module to use this class, it will look as such...


SUB:

Please Login or Register  to view this content.

An example of my problem is a Textbox object. You can get the value like this...

Please Login or Register  to view this content.

You can LET the value like this....

Please Login or Register  to view this content.

However, maybe I am ignorant, but I would bet when you LET that value, behind the scenes there is much more code being executed (find the specific textbox object, enter the value, etc)
(i don't know how MS writes their software nor do I have any knowledge of "true" program objects) But I am just making the point that there has
to be a valid case for when a property is LET with a value, code executes. And i'm sure thats possible, I just don't know how right now lol.



But going back to my philosophy and way I am using this class, I realize that it boils down to....

-Properties hold variables to use later
-Methods use those properties


So, I am all over the place lol. Just trying to make practical sense of it all and leverage these tools.

Thanks, welcome your comments and criticism.

In you textbox example the actual object is referencing the textbox control so it does not have to find it.
It would be the same as creating your class for 'Richard'.

If you want to use the Online property, and include a name I showed the syntax required in my first reply.
It's okay to do that, it's just the class name of userclass and the public variable username all suggested you would be having multiple user objects. Where as you appear to only need one and you pass in the username.
In this sense the username is just an argument as you are not retaining it in the class object only using it to determine something within the class.