"I used the scroll bar on the form buttons for data entry in which I have to drive percentages but excel does not allow me to introduce this format (decimal) in the configuration of the bar Can not be done? Is there any way to fix it? "
The configuration of the buttons form in excel is very limited. The increases that allows both the scroll bar as the spinner must be integers (no decimals allowed). But there is a simple way to achieve the same result.
1. We begin by introducing the sign and zero in cells B3 and C3 respectively. In cell D3 write the formula = C3/100 and in cell E3 draw the scroll bar (you can find on the menu View / Toolbars Tools / Forms ):
2. We click the right mouse button above the scroll bar and select the last option from the popup menu: Format Control. The following window opens:
3. We as a minimum value 0 and maximum 100, and we're going to handle percentages, and link with the cell C3. Accepted.
4. We have succeeded in pressing our scroll bar to the right cell D3 percentage point change per click. Now we only have to hide the column C and objective achieved.
Suggestions:
A) To prevent write in cell D3, and it is a formula and not a data entry, I suggest you use the trick seen in my previous post " Protecting cells with data validation ."
B) If you want the change to occur in each time the scrollbar is less than one percentage point each click in cell D3 change denominator of 100 to 1,000, if you want each click involving a change of 10 basis points (0.10) or change it to 10,000 if you want each pulse involving a change of one basis point (0.01). In both cases you must also change the maximum value and the scroll bar to 1,000 and 10,000 respectively. You can also try to leave this part as dependent variable and do data entry in the list to select from a change you need.
0 comments:
Post a Comment