Ryo2

I'm creating a class module and I'm debating whether to use properties (Get) or functions to return some simple values. I just wanted some input to determine which would be more efficient.

Thanks.

Thinker

For simple values, there probably isn't any difference in efficiency.
I prefer to use properties if either one would do the same thing.

Genna

actually it depends on situations
if my values are static, i would use the properties
otherwise, it would be functions, functions do shorten your coding.
I used to have an application which is about 19 pages until my friend told me to use functions
now it is around 5 pages *wickedly grinz* :>
it is still growing :>

Thinker

Whether or not the values are static has nothing to do with using
properties or methods. If you don't know something about the
question, please don't post.

Ryo2

Thanks Thinker.

Genna: BTW maybe you got it confused with another thing. It doesn't shorten my code whether I use Properties (Let/Get) vs Functions.

Here's a simple example:
Public Property Get MyNameProp() as String
MyName = "SOME STRING"
End Property

Public Function MyNameFunc() as String
MyNameFunc = "SOME STRING"
End Function

Banjo

The way I tend to distinguish between the two is to ask this question:

Does it specify information or operate on information?

The former becomes a property and the latter becomes a method.
That doesn't preclude properties from operating on the data they are setting but I normally limit it validation checks and the like.