why to set up public property

[jaryszek]

Hi,

what is a purpose of setting up public property?

like :

Please Login or Register  to view this content.

Where should i put this? In class module?

What this class name should be?

Best,
Jacek

[romperstomper]

Generally yes you would put a property in a class. It really doesn't matter what you call it (though it's best to avoid VBA or Excel keywords)

[Andy Pope]

Couple of reasons,

creation of read/write, readonly and writeonly properties.
execution of additional code when reading and or writing properties.

Module

Please Login or Register  to view this content.

Class Class1

Please Login or Register  to view this content.

[jaryszek]

thank you very much Andy and Rory!

Great explanation.
Jacek

[jaryszek]

Andy,

i am getting error in your code. Is should be:

Please Login or Register  to view this content.

And i have another error like here:

Screenshot_4.png

can you please help with this?
Jacek

[romperstomper]

Andy's code was (as expected) correct as written - make sure you read the comments!

[jaryszek]

thank you.

So what is a purpose to get error here?

Jacek

[romperstomper]

It was to demonstrate read-only and write only properties.

[jaryszek]

aaa ok. Understand .

thank you!

[Andy Pope]

Here is the code in a workbook.
The 2 compile lines are commented out.

I don't get the error you report so you must have added extra code.