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

Cliff Edwards

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
"ward376" <(E-Mail Removed)> wrote in message
news:cbd84fd0-31e7-4a58-951c-(E-Mail Removed)...
| Can VBA be used to change VBE settings? Specifically, how can syntax
| checking be turned off and variable declaration turned on?
|
| Cliff Edwards

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" <(E-Mail Removed)> wrote in message
news:cbd84fd0-31e7-4a58-951c-(E-Mail Removed)...
> Can VBA be used to change VBE settings? Specifically, how can syntax
> checking be turned off and variable declaration turned on?
>
> Cliff Edwards

Thanks!

Cliff Edwards