![]() ![]() It's vital that you select those in the Form Controls group not the ActiveX Controls as they work very differently and it's the Form Controls that we are using.ĭrag a Spin Button onto your worksheet and drag a Scroll Bar onto your worksheet too. To see the tools, choose Developer > Insert and then select either the Spin Button or the Scroll Bar tool from the Form Controls group. In Excel 2007 click the Office button, choose Excel Options and then enable the Show Developer tab in the Ribbon checkbox in the Popular group. If you don't have this visible, in Excel 2010, choose File > Options > Customize Ribbon and in the second panel make sure that the Developer checkbox is selected. In Excel 2007 and Excel 2010, the spin buttons and scroll bars are accessible from the Developer tab. Today, I'll introduce you to using spin buttons and scroll bars and show you an way to add an interactive element to an Excel chart with a spin button. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work. ![]() Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. Helen Bradley explains how to add interactive elements to an Excel worksheet using scroll bars and spin buttons. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |