Discovering VBA Functions

By Hemanta Sundaray on 2022-05-24

The best way to find out which functions VBA provides is to type VBA, followed by a period. You get a list of items, as shown in the following figure:

VBA Functions

Those with a green icon are functions. If this feature isn’t working, choose VBE’s Tools ⇒ Options, click the Editor tab, and place a check next to Auto List Members.

Auto List Members

Join the Newsletter