Explanation of some properties of VBA controls

Source: Internet
Author: User

VBA Each control has a lot of properties, although can be sorted by classification, but because there is no Chinese explanation, some properties do not know how to use, the following are some of the control properties explained, not all, for reference:

Whether the control is loaded when General AutoLoad (Excel) opens the workbook. (If it is an ActiveX control, it is ignored.) )
Whether the Enabled (form) control can receive focus and respond to user-generated events.
Whether the Locked (form) control is editable.
The name of the name (form) control.
The way Placement (Excel) controls are attached to cells below them (freely floating, moving but not resizing, or moving and resizing).
Whether the PrintObject (Excel) control is printable.
Whether the visible (form) control can be seen or hidden.
Size and position the size of the AutoSize (form) control can be automatically adjusted to show all content.
Height, width (form) or width (in points).
The distance between the left, Top (form) control, or the top edge of the worksheet.
Orientation (form) whether the direction is vertical or horizontal.
Formatting BackColor (form) background color.
BackStyle (form) background style (transparent or opaque).
The color of the bordercolor (form) border.
The type of the BorderStyle (form) border (none or one-wire).
ForeColor (form) foreground color.
The Shadow (Excel) control has a shadow.
The visual appearance of the SpecialEffect (form) border (planar, convex, concave, etched, or convex).
Keyboard and mouse shortcut keys for accelerator (form) controls.
MouseIcon (form) customize the mouse icon.
MousePointer (form) The type of pointer (for example, standard pointer, arrow, I-type) that is displayed when the user places the mouse over a specific object.
TakeFocusOnClick (form) whether the control receives focus when clicked.
Data and Bindings LinkedCell (Excel) link to the range of control values.
The content or state of the Value (form) control.
The delay, in milliseconds, that is specific to the ScrollBar delay (form) after the scroll bar is clicked.
LargeChange (Form) the amount of movement that occurs when a user clicks the area between a scroll box and any scroll arrow.
Max, min (form) The maximum and minimum allowable values.
ProportionalThumb (form) whether the size of the scroll box is fixed or proportional to the scrolling area.
SmallChange (Form) the amount of movement that occurs when a user clicks a scroll arrow in a control.
Structure cycle specific (form) the action to take when the user leaves the structure or the last control on the page (all forms or the current form).
KeepScrollBarsVisible (form) whether the scrollbar remains visible when it is not needed.
ScrollBars (form) controls have vertical scroll bars and/or horizontal scroll bars.
ScrollHeight, ScrollWidth (form) The height or width (in points) of the entire area that can be viewed by moving the scroll bar.
ScrollLeft, ScrollTop (form) the distance (in points) between the left or top edge of the logical form and the left or top edge of the structure.
The amount of change in the size of the image within the Zoom (form) structure.
A data source that is specific to multiple columns of a list box BoundColumn (form).
ColumnCount (form) The number of columns to display.
ColumnHeads (form) as a single row of column headings.
ColumnWidths (form) The width of each column.
ListFillRange (Excel) The area used to populate the list.
ListStyle (form) List style (normal, with option buttons, or with check boxes).
MatchEntry (form) How the control searches for its list when the user is typing (first letter, entire entry, or unspecified)
TextColumn (form) The column to store in the Text property when the user selects a row.
TopIndex (form) items that appear at the topmost position in the list.
Image picture (form) the bitmap to display in the control.
PictureAlignment (form) The position of the background picture (upper left, upper right, center, etc.).
PicturePosition (form) the relative position of the picture with its title (left, top, right, and so on).
PictureSizeMode (form) How the background picture is displayed on the control (cropping, stretching, or zooming).
PictureTiling (form) Whether you want to tile multiple copies of the picture in the control.
Text bold, Italic, size, strikethrough, underline, Weight (form) font properties (bold, italic, font size, strikethrough, underline, and thickness).
Caption (form) identifies or describes the descriptive text of a control on a control.
The default run-time mode for the IMEMode (form) Input Method Editor (IME).
The size of the integralheight (form) control can be resized to display all or part of a line of text.
Whether MultiSelect (form) allows multiple items to be selected.
Text in the text (form) control.
TextAlign (form) The alignment of text in the control (left, center, or right).
WordWrap (form) whether the content of the control wraps at the end of the line.

Explanation of some properties of VBA controls

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.