| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Spinner Button - Incremental Change
Hello,
Currently the Spinner button incremental change apparently only accepts whole numbers. I need to set it to thousandths (.01). Is this possible? -- Thank-you and all suggestions are appreciated. |
|
#2
|
|||
|
|||
|
Cheat!
Link spinner to E6 and in D6 use =E6/1000. \Now D6 changes by 0.001 (thousandth) - use /100 for changes by 0.01 (hundredths) Maybe drag spinner over E6 to hid it. Best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Anauna" wrote in message ... Hello, Currently the Spinner button incremental change apparently only accepts whole numbers. I need to set it to thousandths (.01). Is this possible? -- Thank-you and all suggestions are appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spinner Button Reset | Excel Discussion (Misc queries) | |||
| Change caption on a macro button | Excel Worksheet Functions | |||
| Change Case button? | Excel Discussion (Misc queries) | |||
| Spinner Button properties | Excel Discussion (Misc queries) | |||
| Macro button colour change??? | Excel Worksheet Functions | |||
Linear Mode
