SPIN BUTTON EXCEL HOW TO
In this article, I’ll look at how to use the spin button, scrollbar, option button, and checkbox controls. The user can drag or click spin buttons and scrollbars to increase or decrease a value, too. The combo box and list box controls let the user choose items from a list, and the user can click checkboxes and option buttons to select the items they represent. An option button, for example, can run a macro when the spreadsheet user clicks it. You can add Form Controls items to your worksheets to introduce click-and-drag functionality. Be sure to click only Form Controls items for the purposes of following along with this article. Note that the ActiveX Controls panel uses similar–in some cases, identical–icons, but they perform very different tasks. Hover your mouse over each icon, and a text box will display its name and function. Now look in the right-hand panel, check the Developer checkbox, and click OK.Ĭlick the Developer tab on the Ribbon, and select Insert (within the Developer tab–don’t click the Ribbon’s Insert tab) to view the Form Controls collection. To display the Developer tab, choose File > Options > Customize Ribbon. The Form Controls are on the Developer tab on the Ribbon, which isn’t visible by default and must be enabled.The key to utilizing these features lies in Excel’s Form Controls, which are accessible only from the Developer tab–and that tab isn’t visible in Excel by default. Read on, and I’ll show you how to accomplish these and several other cool Excel tricks. Or, if you wish to limit a spreadsheet user to selecting from a few preset choices, a set of option buttons will do. If you’re developing a spreadsheet that you’ll use over and over again, inserting a spin button or scrollbar will allow you to choose from a predefined range of values using your mouse, instead of typing numbers in with the keyboard. Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets.
0 kommentar(er)
