Spinboxes In MS Excel 2003
 

Can you use non whole numbers in Spin Boxes in excel spreadsheets. Can you
input values less than one( .5, .05, .002) etc. into the incremental change
field in the Spin Box, Format Control tab when you right click on the spin
box?

Spinboxes In MS Excel 2003
 

Chris,

Not in the control dialogue itself, but by setting up a formula that were to
say divide the contents of the cell under the control by two you could create
a gearbox - ie a change increment on one divided by two would give you a half.

Hope this is clear

Corin

Spinboxes In MS Excel 2003
 

Corin,
Thanks for all of your help. I can now do real time ROI calcs with the
click of my mouse.

"Corin" wrote:

Chris,

Not in the control dialogue itself, but by setting up a formula that were to
say divide the contents of the cell under the control by two you could create
a gearbox - ie a change increment on one divided by two would give you a half.

Hope this is clear

Corin