UserForm and Frame Members

Use the UserForm and Frame objects as containers for controls. Use the UserForm object to create a dialog box. Use the Frame object to group a set of controls on a dialog box. The UserForm and Frame objects have the following members, all of them key members, covered in the following reference section:

1 UserForm only

ActiveControl

BackColor

BorderColor

BorderStyle

CanRedo

CanUndo

Caption

Controls

Copy

Cut

Cycle

DrawBuffer 1

Enabled

Font

ForeColor

InsideHeight

InsideWidth

KeepScrollBarsVisible

MouseIcon

MousePointer

Paste

Picture

PictureAlignment

PictureSizeMode

PictureTiling

PrintForm

RedoAction

Repaint

Scroll

ScrollBars

ScrollHeight

ScrollLeft

ScrollTop

ScrollWidth

SetDefaultTabOrder

SpecialEffect

UndoAction

VerticalScrollBarSide

Zoom

Zoom

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.