Vba label control in Excel

The Label control is used to display a plain text to the user.

For example, the label control can be used to specify what to input in a textbox control or

what to select with a combobox or listbox control and so on.

Also, Label can be used to display an output text directly in the form instead of a message box.

The label control is not editable manually and is just fro displaying information to the user.

Properties of a label control

The main properties of label control are as discussed below


This property specifies the text to be displayed in the label control


This property specifies the background style of the label control

It may be set to transparent or any other colour.


This property is important with respect to this control and is used to set the size and other visual attributes of the control.


Though this property is common to all controls, this is important with respect to label control in the sense,

some informtion can be hidde from the user, if there is a need be, using this property.

Regarding events, The kabel control events are rare and generally not used at all.

Since, this control is just for displaying purpose, there is not much that can be done with the label events.

The following figure shows the label control that instruts the user to input text in the textbox control

excel vba label control


You can find similar Excel Questions and Answer hereunder

1) Here an explanation about buttons in VBA

2) How to control forms in Excel VBA

3) Here an explanation about checkbox and how to control checkboxes in Excel VBA

4) Here an explanation about text box and how to control text boxes in Excel VBA

5) Here an explanation about spin button and how to control it using VBA

6) What are ActiveX controls in VBA. Here some good explanations

7) Here an explanation about list box and how to control list boxes in Excel VBA

8) Here an explanation about combo boxes and interfacing with your user in Excel VBA

9) Here an explanation about the options in button control in Excel VBA

10) Here an explanation about frames and how to control frames in Excel VBA


Here the previous and next chapter