devxlogo

GetVBASetting – Retrieve a setting for the Visual Basic VBA code editor

GetVBASetting – Retrieve a setting for the Visual Basic VBA code editor

Const HKEY_LOCAL_MACHINE = &H80000002' read the value of a setting for the VBA editor from the Registry'' Possible values for SettingName are:'   AutoQuickTips2      (0/1)'   AutoStatement2      (0/1)'   AutoValueTips2      (0/1)'   BackGroundCompile   (0/1)'   CompileOnDemand     (0/1)'   DragDropInEditor    (0/1)'   EndProcLine         (0/1)'   FontFace            (a string, eg "Courier New")'   FontHeight          (an integer number)'   OBGroupMembers      (0/1)   (OB=Object Browser='   OBSearchHeight      (an integer number)'   RequireDeclaration  (0/1)'' If you pass an unrecognized setting name, it raises error 5'' Requires the GetRegistryValue functionFunction GetVBASetting(ByVal SettingName As String) As Variant    GetVBASetting = GetRegistryValue(HKEY_CURRENT_USER, _        "SoftwareMicrosoftVBAMicrosoft Visual Basic", SettingName, "***")    If GetVBASetting = "***" Then Err.Raise 5End Function

See also  5 Tips for Working With an Onsite Interpreter
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist