Set and Let Property????

[AmazingJoy]

Hi guys! Can anyone please explain me the difference between the two? Sorry, I'm a newbie here and my question might sound stupid to you but hey! It's better to ask that to assume...

[FATBOYPEE]

The property settings Let & Get

are commonly used to interface any variables that are not objects (ie Integer Long, String etc). You need 3 things for Read & Write:

a Let property to put your data in

A Get property to Get your data out

and a private container of the same type you Let & Get:

' Declaration of Private Data Container used for anything but objects
Private m_MysTring as String

' Public interface to place data variables (anything but objects)
Public Property Let myString(byval sMyString as String)
' Place any manipulation code also in here
m_MsyString = sMyString

End Property

Public Property Get MyString() as String
' Place any other manipulation code in here.
MyString = m_MysTring

End Property

Set on the other hand is for objects: Typically you need 3 things

' Private Variable Container
Private m_ADODBRS as ADODB.RecordSet

' Set Property
Public Property Set ADODBRS (ARS as ADODB.RecordSet)

Set m_ADODBRS = ARS

End Property

' Get Property
Public Property Get ADODBRS() as ADODB.RecordSet

Set ADODBRS = m_ADODBRS

End Property

FATBOYPEE

[AmazingJoy]

That was a great help!