Change VBE Settings

[ward376]

Can VBA be used to change VBE settings? Specifically, how can syntax
checking be turned off and variable declaration turned on?

Cliff Edwards

 

[Jim Rech]

The VBE programmability object model does not support changing VBE settings.
I think you'd have to investigate making the changes via registry entries.
The setting are stored under this key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common

--
Jim
| Can VBA be used to change VBE settings? Specifically, how can syntax
| checking be turned off and variable declaration turned on?
|
| Cliff Edwards

 

[Peter T]

There does not appear to be any exposed property you can change.

However you could add code to read/write 0/1 to
HKCU\Software\Microsoft\VBA\6.0\Common\RequireDeclaration

otherwise SendKeys

Regards,
Peter T

 

[ward376]

Thanks!

Cliff Edwards