RDO is Hierarchy model where as ADO is Object model. ADO can access data from both flat files as well as the data bases. I.e., It is encapsulation of DAO, RDO , OLE that is why we call it as OLE-DB Technology. 

Set - Value is assigned to ActiveX Object from the form.

Let - Value is retried to ActiveX Object from the form.

Get - Assigns the value of an expression to a variable or property.

User defined functions can be created into the Microsoft spreadsheet. Spreadsheets can be customized according to the user needs by using VB applications. To create visual basic functions useful for spreadsheet you need to click Tools and select Macros where you will need to click on Visual basic editor.

Some of the rules which should be followed while naming a variable in VB are as follows: 

1) Characters should be less than 255.

2) Space between characters should be allowed.

3) A variable should begin with a number.

4) Period may not be permitted.

Dim obj as OBJ.CLASS with eitherSet obj = New OBJ.CLASS orSet obj = CreateObject(OBJ.CLASS?) orSet obj = GetObject( , OBJ.CLASS?)orDim obj as New OBJ.CLASS 

DAO (Data access object ) is used for accessing data before ado it was used for database installed on same sys where the application resides.

RDO (Remote data object ) is used for accessing remote data

ADO (Active data object ) most powerful till date it is nothing but combination of both DAO and RDO 

- When u build connection with database through coding, then its ADODB.When u build connection with database through ADO component, then its ADODC.

- ADODB is a ActiveXdll and ADODC is a ActiveXcontrol.

- No Need to bind with controls in ADODB whereas in ADODC we should bind with controls.

Tree view control is designed to display data that is hierarchical in nature, such as organization trees, the entries in an index, the files, directories on a disk. It is often used in conjuction with the List view control, which is used to display the contents of the folder selected in the tree view.

List view control displays data as listitem objects. The control excels at representing subsets of data or discrete objects.The list view property is often used in association with a tree view control.