Tutorial Details
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

UserForm Properties List and Explanation

Add to Favorites
Author: | Edits: don

This is a listing of all properties for the UserForm in Excel. Each property includes an explanation of what it is, what values you can use for it, and how you might use it.

UserForm Properties

Property Description

The name of the UserForm. This name will be used to reference the form, including when you need to open, close, or hide it.


Background color of the UserForm.

BorderColor Color of the border for the UserForm. This will not appear unless you set the next property to 1 - fmBorderStyleSingle.

If the form will have a border or not.

0 - fmBorderStyleNone - there will be no border.

1 - fmBorderStyleSingle - a border will appear with the color that was specified in the BorderColor property.

Caption Text that appears on the top of the UserForm. Basically, this is the title of the form's window.

Controls how it works when a user is tabbing (hitting the Tab key) through a series of controls.

0 - fmCycleAllForms - the user can tab through all of the controls in the form without having to explicity select or click another control.

2 - fmCycleCurrentForm - the user can only tab through the controls within the same Frame or MultiPage control within the form. To change the focus outside of the current Frame or MultiPage control, the user will have to explicity click outside of it.

(This is a seemingly confusing property that you will most likely never need to use.)

DrawBuffer The number of pixels set aside for off-screen memory in rendering a frame. (This usually doesn't need to be adjusted unless the form is flickering.)

If the UserForm can be used or not - it's best not to mess with this from the properties window.

True - form is enabled and can be used regularly.

False - form is disabled and cannot be used by the user or respond to any user-generated events.


Allows you to change the size, style, and font of text; it also allows adding an underline or strikeout to text.

This property for the UserForm controls the default Font settings for any controls that are added to the form; however, this will not change the Font characteristics of any element that was previously added to the form before this property was changed.


Controls the default color of text within the form.

This changes the text color for these controls: Label, TextBoxFrameTabStripMultiPage.

The default text colors can be overridden for each control individually.

Height The height of the form, in points.
HelpContextID Allows you to attach a custom help file to the form that is called when the user pressed F1. Leave this at its default 0 unless you made a custom helpfile in Windows and know the HelpContextID for it.

If scroll bars will remain visible when not required. (Scrollbars must be set to visible using the ScrollBars property for this to do anything.)

0 - fmScrollBarsNone - no scroll bars appear when not needed.

1 - fmScrollBarsHorizontal - horizontal scroll bars always appear.

2 - fmScrollBarsVertical - vertical scroll bars always appear.

3 - fmScrollBarsBoth - both horizontal and vertical scroll bars always appear.


The distance of the form from the left edge of the screen.

To use this feature, set the StartUpPosition property to 0 - Manual


Custom mouse icon. You must use an approriate icon image for this property, .ico or .cur files.

Set the MousePointer property to 99 - fmMousePointerCustom when using this option.


The type of mouse pointer displayed when the user hovers the mouse over the form.

0 - fmMousePointerDefault

1 - fmMousePointerArrow

2 - fmMousePointerCross 

3 - fmMousePointerIBeam

6 - fmMousePointerSizeNESW

7 - fmMousePointerSizeNS

8 - fmMousePointerSizeNWSE

9 - fmMousePointerSizeWE

10 - fmMousePointerUpArrow

11- fmMousePointerHourGlass

12 - fmMousePointerNoDrop

13 - fmMousePointerAppStarting

14 - fmMousePointerHelp

15 - fmMousePointerSizeAll

99 - fmMousePointerCustom - set this option when using a custom icon for the MouseIcon property.

Picture Background image to use for the form.

Alignment of the background picture if it was set in the Picture property.

0 - fmPictureAlignmentTopLeft

1 - fmPictureAlignmentTopRight

2 - fmPictureAlignmentCenter

3 - fmPictureAlignmentBottomLeft

4 - fmPictureAlignmentBottomRight


How to display the background picture if one is being used for the form.

0 - fmPictureSizeModeClip - image displayed in its actual size.

1 - fmPictureSizeModeStretch - image is stretched to fill the entire form, even if it distorts the image.

3 - fmPictureSizeModeZoom - image is stretched to fit the form while maintaining its original ratio. It will not expand beyond the edges of the form, which means it may not fill the entire background of the form, unless the PictureTiling property is set to True.


Allows for a background image to be tiled. This allows for an image that would not fill the entire background of the form to be repeated until it is covered.

True - image is tiled to fill the background of the form.

False - image is not tiled.


Controls the text display direction on systems where the user might read right-to-left.

True - user reads right-to-left.

False - user reads left-to-right. (default value)


Controls if the form has scroll bars.

0 - frmScrollBarsNone - don't show scroll bars.

1 - frmScrollBarsHorizontal - show horizontal scroll bars.

2 - frmScrollBarsVertical - show vertical scroll bars.

3 - frmScrollBarsBoth - show both horizontal and vertical scroll bars.

ScrollHeight The height, in points, of the total area that can be viewed by moving the scroll bars on the form.
ScrollLeft The distance, in points, of the left or top edge of the visible form from the left or top edge of the logical form.
ScrollTop The distance, in points, of the left or top edge of the visible form from the left or top edge of the logical form.
ScrollWidth The height, in points, of the total area that can be viewed by moving the scroll bars on the form.

Sets a UserForm to be modal or modeless in its display. Read-only at run time.

True - user cannot do anything in Excel while the UserForm is being displayed.

False - user can work in Excel while the UserForm is being displayed. (generally not recommended)


Some basic formatting/framing options for the UserForm.

0 - fmSpecialEffectFlat

1 - fmSpecialEffectRaised

2 - fmSpecialEffectSunken

3 - fmSpecialEffectEtched

6 - fmSpecialEffectBump


Controls the position of the UserForm when it is first opened.

0 - Manual - starting position is specified by the Top and Left properties.

1 - CenterOwner - starting position is the center of the Excel window.

2 - CenterScreen - starting position is the center of the computer screen, even if it is not within the Excel window.

3 - WindowsDefault - starting position is the upper-left corner of the computer screen.


Additional information about the form. This can be up to 2048 characters in length.

You can use this property to, for instance, store information about the form and then display it as needed.


The distance of the form from the top edge of the screen.

To use this feature, set the StartUpPosition property to 0 - Manual


If you want to show the question mark help button in the title bar of the UserForm window. Read-only at run time. This property does not apply to the Macintosh.

True - show the help button.

False - don't show the help button.

WhatsThisHelp Determines whether context-sensitive Help uses the pop-up window or the main Help window. Read-only at run time. This property does not apply to the Macintosh.
Width The width of the form, in points.

Allows you to set a zoom level for everything in the UserForm. The form itself will remain the same size, but the contents will zoom in or out accordingly.

The value for this property is a whole number that represents percentage.

50 = 50%

100 = 100%


Question? Ask it in our Excel Forum