Share via

Excel UserForm Frame and Border Color

S. Bode 26 Reputation points
2022-09-20T12:26:46.61+00:00

System OS - Windows 10
Application - Excel 2019

I use UserForms to present or collect information from the end user. Previously the UserForm frame and its color looked like the following:

242939-userform-original.jpg

Currently in the VBA editor, the UserForm looks like the the image below and seems very similar to the former style of the UserForm.

242997-userform-vba-editor.jpg

When the current UserForm is displayed to the end user, it looks like the image below:

243022-userform-display.jpg

I am not proficient in Windows, but I suspect that something must have altered some systemwide frame and color parameters. I would like to know that parameters might have caused the change to the display style for the UserForm and how to get the current values of these parameters as well as the default or former values of these parameters that altered the style of the UserForm frame and colors.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,657 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
Accepted answer
  1. Nothing Left To Lose 396 Reputation points
    2022-09-23T12:46:16.067+00:00

    Re: UserForm settings

    First- a "Frame" on a userform (UF) is a control that can be added to the UF.
    It is used to group some or all controls on a UF.
    I don't recommend its use (it is a memory hog).

    Second - The Properties window of a UF displays options that can be set/changed for a UF or
    for any control on the UF. Display the Properties window from the View menu or by
    pressing the F4 key.

    Third - The Windows colors setting also "help" or interfere with what colors are displayed to the user. Please note you cannot set the users Windows color settings; so what you see may not be what the user sees.

    244351-image.png

    '---
    Nothing Left to Lose

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nothing Left To Lose 396 Reputation points
    2022-09-23T00:10:54.53+00:00

    Re: speckled appearance of user form

    That looks like the "Show Grid" option has been selected.

    243999-image.png

    '---
    Nothing Left to Lose
    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
    (free excel programs)

    0 comments
  2. S. Bode 26 Reputation points
    2022-09-23T10:48:22.12+00:00

    Thank you for taking the time to respond.

    To clarify, the two separate, but possible related, issues that I have with the UserForm are: (1) the UserForm frame border, i.e. the perimeter or outside border, and (2) the UserForm title, i.e. topmost portion of the UserForm, background color.

    In the earlier end user view and the current VBA editor view,
    (1) the UserForm frame border consists of a thick line with color and a thin black line.
    (2) the UserForm title background has color.

    In the current end user view,
    (1) the UserForm frame border consists of a thin black line.
    (2) the UserForm title background is white.

    In regard to the grid, you are correct that the grid is generally enabled in the VBA editor to facilitate the layout, but the grid is not displayed to the end user, nor is it part of the two issues.

    I hope that is clarification of the issues is helpful and can possibly result in a solution.

    Kind regards,
    S. Bode

    0 comments
  3. S. Bode 26 Reputation points
    2022-09-24T01:45:55.217+00:00

    Thank you for your response and time.

    0 comments