'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Visual Basic Editor Font Size Not Changing in Windows
Question details
The user is unable to successfully change or save the font size settings within the Visual Basic Editor.
- Product
- Visual Basic Editor
- Device & OS
- Windows
- Scenario
- Attempting to increase or modify the code font size in the VBA editor for better code readability.
- Observed behavior
- The font size settings revert or fail to apply when Windows display scaling is set to a value higher than 100%.
Ensure you save any open documents and close background applications before modifying system display settings, as your screen will briefly refresh during the process.
Temporarily Adjust Windows Display Scaling to 100%
Bypass the scaling interference by temporarily setting your Windows display scaling back to the default 100% before applying the font size change.
High DPI scaling settings in Windows can sometimes interfere with older interface components like the Visual Basic Editor, preventing them from registering configuration changes.
Right-click on an empty area of your Windows desktop and select 'Display settings' from the context menu, or navigate to Start > Settings > System > Display.
Scroll down to the 'Scale and layout' section. Note your current scaling percentage (e.g., 125% or 150%), then click the drop-down menu and change it to 100%.
Open your Visual Basic Editor. Go to the top menu and click Tools > Options. Select the 'Editor Format' tab, choose your desired font size, and click OK.
Once the new font size is successfully applied in the editor, return to the Windows Display settings and revert the 'Scale and layout' drop-down back to your original percentage.
Edit VBA Macros Seamlessly in WPS Office
WPS Office provides a robust, fully compatible Visual Basic Editor for handling your macros without the hassle. Experience smooth coding and easy customization within WPS Spreadsheets.
- 1. Open WPS Spreadsheets: Launch WPS Office and open a new or existing spreadsheet document.
- 2. Access the VBA Editor: Navigate to the 'Tools' tab on the top ribbon and click on 'Visual Basic Editor', or simply press Alt + F11 on your keyboard.
- 3. Customize Editor Format: Inside the editor, click on 'Tools' > 'Options' from the top menu bar, then switch to the 'Editor Format' tab.
- 4. Save Preferences: Select your preferred font size and style from the available lists, then click 'OK' to apply your settings.
Frequently Asked Questions
Why does Windows display scaling prevent VBA font changes?
High DPI scaling settings in Windows can interfere with the way certain legacy interfaces like the Visual Basic Editor process user inputs. The editor fails to properly map the 'OK' button click when scaling is above 100%, causing the save action to be ignored.
Can I change the font style and color in the Visual Basic Editor?
Yes, you can customize both the font style and text colors. Go to Tools > Options > Editor Format in the VBE. From there, you can select specific foreground and background colors for different code elements like keywords, comments, and text.
Will the font size reset if I restart my computer?
No. Once the font size change is successfully applied while Windows scaling is set to 100%, the setting is permanently saved to your registry. It will persist even after you restore your preferred display scaling and reboot your PC.
