Decimal Values (currency) when using scroll bars

K

K Luttrell

I’m trying to create a decision making tool that uses a slider control to
change a cost per unit field. I used a scroll bar from the Forms toolbar.
However, this control is not able to increment decimal values. Because I am
using currency, I need .01 detail, however, any decimal value in the
‘Incremental change’ field in the ‘Control’ tab of the ‘format control’ for
the slider is replaced with ‘0’. I’ve currently linked the control to
another cell and the relevant cell has a ‘/100’ formula, but now my users
can’t type a value directly. I’d appreciate any help. Thanks.
 
D

David McRitchie

Hope it's something simple like
Tools, Options, Edit, uncheck fixed decimal places

Also check your cell formatting.

What happens if you type .99
 
K

K Luttrell

Thanks, but no luck. fixed decimal places was unchecked. I tried changing
the cell formating from General to Number (Decimal places 2). The scroll bar
still only increments whole integers. I can type a decimal value, however as
soon as I hit the up or down arrow on the scroll bar it goes to the next
highest or lowest integer. For my target user base, I'm more concerned with
giving them a slide control than a direct entry option, but it would have
been nice to have both. Thanks for your help.

David McRitchie said:
Hope it's something simple like
Tools, Options, Edit, uncheck fixed decimal places

Also check your cell formatting.

What happens if you type .99
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

K Luttrell said:
I'm trying to create a decision making tool that uses a slider control to
change a cost per unit field. I used a scroll bar from the Forms toolbar.
However, this control is not able to increment decimal values. Because I am
using currency, I need .01 detail, however, any decimal value in the
'Incremental change' field in the 'Control' tab of the 'format control' for
the slider is replaced with '0'. I've currently linked the control to
another cell and the relevant cell has a '/100' formula, but now my users
can't type a value directly. I'd appreciate any help. Thanks.
Click to expand...
Click to expand...
 
Top