how do I turn off option explicit statement in VB

[Guest]

I can't get some projects to work without turning it off but have no idea how
to do it.

 

[Tom Ogilvy]

select the line that says

Option Explicit

at the top of the module and delete it.

Of course the standard advice is to fix the problems identified by Option
Explict - otherwise, you may not get correct results even it it runs.

 

[Andy Pope]

Hi,

For existing code you can simply comment out the Option Explicit line.

To stop it automatically appearing at the top of new code use the menus
within VBE, Tools > Options. On the editor tab is a checkbox 'Require
Variable Declaration'.

Cheers
Andy