Auto List Members option

If the Auto List Members option is set, VBE provides some help when you're entering your VBA code. It displays a list that would logically complete the statement you're typing.

I like this option and always keep it turned on. Figure 3-6 shows an example (which will make lots more sense when you start writing VBA code).

Figure 3-6:

An example of Auto List members.

Figure 3-6:

An example of Auto List members.

^ PERSONAL.XLSB Mod ule 1 (Code)

DBS

(General) jJ |ïest

d

Public Sub Test()

activeworkbook.

End Sub AcceptAIIChanges

-

Activate

^ Activée h art

iá?iActiveSheet j\

Ad dTo Favorites ^

El? Application

AppiyTheme

-

a

- < _l

jJj

0 0

Responses

Post a comment