get/Let in function and when to use?

[Ruegen]

I've noticed on this page



http://www.cpearson.com/excel/option...rocedures.aspx

using "get/let" inside of a function name on creation

Could someone please explain to me when to use either and their purpose?

Normally I just write the function name without them

[orange]

see Class modules and related info here

The Get/Let is not used with standard modules.

[Ruegen]

see Class modules and related info here

The Get/Let is not used with standard modules.

So only with classes? I've made my own class objects before however I didn't use get/let....

[Ruegen]

from what I see get locks the variables where as let lets parameters pass...?

[orange]

I am not an authority on class modules. However, see this example for more info on Get/Let.

[Ruegen]

I am not an authority on class modules. However, see this example for more info on Get/Let.

Thanks, I sort of understand it now but I don't really have a use for it yet - I'm hoping it will come handy in the future...'

thanks orange