It could be just to get one piece of information or many. The purpose of the scroll bar can be to get a piece of information and use that to create the kind of table we have just seen under the revious example. 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!
CREATING CELL MENUES IN EXCEL FOR 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.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.
CREATING CELL MENUES IN EXCEL FOR MAC WINDOWS
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.
0 kommentar(er)
