Input range Reference to the range containing the values to display in the drop-down list.Ĭell link Returns the number of the item that's selected in the combo box (the first item in the list is 1). More Controls A list of additional ActiveX controls. Image A control that embeds a picture into a form. Label Text added to a worksheet or form to provide information about a control or the worksheet or form. You can move through a page of values by clicking between the scroll box and a scroll arrow. Scroll bar A control that scrolls through a range of values when you click the scroll arrows or when you drag the scroll box. To increase a value, click the up arrow to decrease a value, click the down arrow. Spin button A button that can be attached to a cell or a text box. Toggle button A button that remains pressed in when clicked, and then releases when it is clicked again. You can either select a choice from the list or type your own entry in the box. List box A box that contains a list of items.Ĭombo box A text box with a drop-down list box. Option button A button used to select one option from a group of options. Text box A box in which you can type text.Ĭommand button A button that initiates an action when it is clicked. You can have more than one check box checked on a sheet at a time. To set the properties for ActiveX controls, and get more information about these controls and the properties available for each control, see Visual Basic Help.Ĭheck box An option you can turn on or off by selecting or clearing it.