[AccessD] Option Explicit

Rocky Smolin rockysmolin2 at gmail.com
Sun Nov 7 17:11:51 CST 2021


Wish I done knowed that 20 years ago.


r
On Sun, Nov 7, 2021 at 1:32 PM jack drawbridge <jackandpat.d at gmail.com>
wrote:

>  Arthur,
>
> How do you add Option Explicit in VBA?
> *Activate Option Explicit in VBA*
>
>    1. First, open the Visual Basic Editor and in the tools menu click on
>    the options.
>    2. After that, in the options in, go to the editor tab and tick mark
>    “Require Variable Declaration”.
>    3. In the end, click OK.
>    4. Once you do that, VBA will add option explicit whenever you add a new
>    module.
>
> jack
>
> On Sun, Nov 7, 2021 at 4:28 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > I recollect that there is a setting that automatically includes "Option
> > Exlcit" whenever I create a new module, but cannot find it in Access 365.
> > I'm tired of typing it again and again.
> > Can anyone tell me where it is?
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list