![]() ![]() There are 30 Student Ids, in total on the SCValue sheet, so we want to have the same number for the scroll bar. Read More: Why We Use Form Controls on a Worksheet? Adding the Developer Tabġ) First things first, in order to access the Developer Tab, go to File>Options>Customize Ribbon and make sure Developer Tab is checked, as shown below.ġ) We have two sheets, one called Scrollbar sheet and the other called SCValue.Ģ) In the sheet called SCValue, we have a range set up with a list of Student Ids and the corresponding Student Names, as shown below.ģ) In order to insert a scroll bar on the sheet called Scrollbar, we go to Developer>Controls>Insert>Form Controls>Scroll Bar as shown below.Ĥ) Insert the scroll bar in the same way one would a standard shape, and resize it as shown below.ĥ) Right-click the scroll bar and select Format Control.Ħ) Set the minimum value to 1, the maximum value to 30, the incremental change to 1, the page change to 10, and set the Cell link to $A$5. So, let’s get started with a few simple examples, to illustrate how to use form controls in Excel. Form controls are accessed from the Developer Tab in Excel and they can greatly enhance one’s worksheet, report or dashboard. ![]() In order to achieve this, you will have to use form controls. You can give your worksheets form-like functionality without ever having to use VBA.
0 Comments
Leave a Reply. |