The Properties pane

Everything that you see in Excel/VBA, such as cell ranges, worksheets, charts, and so on, has a set of characteristics or properties associated with it. For example, a range of cells will have properties like the width of cells or the value stored in a cell. We can view and change these properties in the Properties pane - displayed in the lower left of the editor. Its purpose is to list those properties that are associated with the object currently selected in the Project Explorer. In the example here, Sheetl has been selected in the Project Explorer, and therefore, the properties associated with this object are displayed in the Properties window.

0 0

Post a comment