![forms button excel 2011 mac forms button excel 2011 mac](https://4.bp.blogspot.com/-nZGme6ehxGo/WDzCuPL3TsI/AAAAAAAAAHw/cQ3EyAXkJBcvLJGA2O5ndoRBwYp0rz_RwCEw/s320/cad-vancouver-tech.jpg)
Thanks to Blog Member azamtokhi for encuraging me to add these! This relates to a NEW example. One more thing, what we have created is a form based scroll bar not an ActiveX scroll bar … not that it really matters here!įollowing on from a comment I have added the following together with a file that you should find helpful. Well, that’s it! A really useful thing to know!
FORMS BUTTON EXCEL 2011 MAC HOW TO
If you want decimals … well, see if you can work out how to make that work … it’s not too difficult! you can only use integers for the values to put into the scroll bars minimum value, maximum value and incremental value, that is.
![forms button excel 2011 mac forms button excel 2011 mac](https://i.stack.imgur.com/7kTvb.png)
arrange them as YOU want … remembering who will use you work and how.Now click away from the scroll bar to deselect it and then use it!.Finally, click on the cell link: this is the cell where your appraisal score will appear … in the section 3 screenshot we would choose cell link F26 for the score for “Delivering results and quality”.leave the page change at 10 … if you click in a scroll bar next to the slider rather that on the scroll bar arrows, your numbers change by 10 not incrementally one by one … change it to 3 or 5 of 20 as you wish.we want the incremental change to be 1 … that is, if you use the Windows version of Excel, click on the scroll bar arrows and the bar moves one number at a time.we want the maximum value to be 100 … in your case that might not be true.the current value is 0 … in some cases this might not be true, it depends which cell you have selected when you create the scroll bar … change it to WHATEVER value you want … 0 is fine here.