You can also type the property name in the Visual Basic Help Search box. For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help topic.

Tip: You can also right-click the text box, and then click Properties. The type of pointer that is displayed when the user positions the mouse over a particular object (for example, standard, arrow, or I-beam).

The location of the picture relative to its caption (left, top, right, and so on). The visual appearance of the border (flat, raised, sunken, etched, or bump). The type of border (none or single-line). The background style (transparent or opaque). The distance between the control and the left or top edge of the worksheet. Whether the size of the control automatically adjusts to display all contents. Whether the contents of the control automatically wrap at the end of a line. How text is aligned in the control (left, center, or right). Whether the control is visible or hidden.įont attributes (bold, italic, size, strikethrough, underline, and weight).īold, Italic, Size, StrikeThrough, Underline, Weight (Form)ĭescriptive text on the control that identifies or describes it. The way the control is attached to the cells below it (free floating, move but do not size, or move and size). Whether the control can receive the focus and respond to user-generated events. Whether the control is loaded when the workbook is opened. Summary of label properties by functional category

Tip: You can also right-click the label, and then click Properties.

Excel vba insert text box