From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Using scroll bars and spin buttons to facilitate forms creation

Using scroll bars and spin buttons to facilitate forms creation - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using scroll bars and spin buttons to facilitate forms creation

“

- [Instructor] In this worksheet, 2 we're seeing two examples of form controls, 3 a scroll bar and a spin button. 4 They're very similar. 5 The scroll bar does have an advantage in ease of use 6 when dealing with larger numbers. 7 You've probably seen these too, 8 not only with internet usage, 9 but perhaps in some Excel worksheets. 10 They're easy to use and they're, 11 if not self-explanatory, fairly close. 12 I've got a scroll bar up here. 13 I'm going to drag this slider bar to the right a little bit. 14 Keep an eye on cell C2 as I'm doing this. 15 Typically, form controls are linked to a certain cell, 16 in this case C2. 17 The chart to the right is also linked to cell C2, 18 and so when I finally let go of the mouse here, 19 the number 35 is present. 20 We also see that being reflected in the chart. 21 Now, if I need to change the score, 22 I can certainly use the slider bar, 23 or if it's nearby, maybe…

Contents