#Spin button excel 2013 how to#
#Spin button excel 2013 mac#
#Spin button excel 2013 windows#

LetвЂ™s say that the minimum amount that we want this mortgage calculator to work for is 100,000 and the maximum is one million. In this worksheet weвЂ™re looking at how we could possibly scale a range of 0 to 30,000 to actually work for us. To see how we would deal with the situation where the amount borrowed is a much larger figure than we can use in the spin button control letвЂ™s have a look at this worksheet. And weвЂ™re going to have to find a way around it which of course can be done easily. So weвЂ™re going to have problems controlling that. So right now that would cause us some problems in trying to add the mortgage amount which is in the region of 200,000 or more when the maximum value is 30,000. One of them is that they only return integer values and the maximum value is 30,000. But there are some limits to spin buttons that weвЂ™re going to have to get around. So thatвЂ™s a spin button control that you can use to control this sort of value. And when I get to 20 it wonвЂ™t go any lower. You can see I can click up but when I get to 30 I canвЂ™t click it any more and then it will click down. So IвЂ™m just going to click outside it and now I can test it. Now if I click on the spin button right now nothing is going to happen because itвЂ™s still active. ThatвЂ™s because that was the starting value. You can see that the cell value changed to 25. And cell link is a pointer to the cell that I want the value to be inserted in so IвЂ™m going to click in here and then click in this cell because this is going to be my link cell and click Ok. Now these have to be integers so one is the smallest value. And the incremental changes how big a change do I want to happen with each click of the button. So weвЂ™re going to move between 20 and 30. And then IвЂ™m going to make the maximum value the 30. So I can start it at for example 25 and then I can set its minimum value which I had previously set to 20 so all our mortgages are going to tested between 20 and 30 years in length. To start off with I can set its current value. And this gives me my options for formatting the control. IвЂ™m now going to right click it and choose Format Control. Now I can resize it later on but IвЂ™m going to start by drawing this size. IвЂ™m going to click here on the spin button control and then IвЂ™m going to click and drag to create the control on my worksheet. And what we want are the simple form controls because theyвЂ™re the easiest to use. Now the Active X controls look pretty much the same thing but they work very, very differently. So once youвЂ™ve got the Developer toolbar available click it and then take this Insert option and you want the form controls. In Excel 2007 youвЂ™ll go here because there will be an option here for Show the Developer Toolbar in the Ribbon. It itвЂ™s not choose File and then Options and in Excel 20 youвЂ™ll go to the Customize Ribbon button here and youвЂ™ll check this Developer tab here so that turns it on. Well first of all you have to have the Developer tab available. So letвЂ™s see how we would add the spinner control to this particular worksheet. When we increase the term on the mortgage by clicking on the up arrow the overall payment is reduced. ItвЂ™s been set to work between 20 and 30 so it will take a value between 20 and 30 years and every time I click the down arrow it decrements this cell by one so that the overall payment per month on the mortgage is increased because the term is much shorter. Here is a copy of the worksheet that weвЂ™re going to be working on and this is the spin button control. Before we get started with spinner controls letвЂ™s have a look and see what weвЂ™re talking about. In this tutorial weвЂ™re going to have a look at creating spin buttons in Excel to make data entry just about as much fun as data entry can be.

#Spin button excel 2013 how to#

It also explains how to scale the value that the control provides so it can provide percentages and very large or very small values. This video explains how to access the Developer tab, then, how to add the spin button form control and, finally, how to set up the control. Using a spin button, a user can click the button to increase or decrease a value in a worksheet cell. Learn how to use a spin button (also called a spinner) form of control in Excel to aid in data entry.

#Spin button excel 2013 mac#

Add Mac Keyboard Icons to Word documents (and other things).

#Spin button excel 2013 windows#

Print a List of Files in a Windows Folder.

Left Arrow to Get to the Bottom of a Word Document - Mac Only Stupidity.

Copy Excel Formulas Without Updating References.

Move a Paragraph Up or Down in Microsoft Word (Mac).

Clean Up Time! How to find and remove big files.

SAVE yourself daily FRUSTRATION - Start Task Manager with one click!.

Excel Templates To Make Marketing Easier.

Let there be light! Testing out the amazing Benq ScreenBar.