Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spinner control to increment percentages
How can I use a spinner control to increment % numbers in the linked cell? I
believe I need to use a second cell for the calculations but I don't remember the technique |
#2
|
|||
|
|||
Link the spinner to cell A1 (for example); set MIN to 0, MAX to 100
In cell B1 (say) use =A1/100 to get values from 0 to 1. Remember that 25% is really 0.25 when you do any math with it; if you wish you could format B1 with the % tool. This will give you steps 0, 0.1, 0.02..... 0.99, 1 To get more precision set MAX to 1000 and use =A1/1000. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KG" wrote in message ... How can I use a spinner control to increment % numbers in the linked cell? I believe I need to use a second cell for the calculations but I don't remember the technique |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) | |||
Why is pointer and keyboard control is lost in certain Excel file. | Excel Discussion (Misc queries) | |||
control keys | Excel Worksheet Functions |