Spin box min/max

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

biztools - 21 Mar 2006 03:01 GMT

I put a spin box linked to a cell containing an item cost of 1.50
because the items cost is part of a cutting test I want the user to b
able to increase the cost in increments of .01, the spin box increase
by 1.00 and the coding will not accept under 1.00, is there a wa
around this or ?
Any help will be much appreciated

Reply to this Message

Dave Peterson - 21 Mar 2006 03:17 GMT

Are you using a linked cell?

If yes, then use a helper cell that uses the linked cell:

=a1/100

(if A1 was the linked cell)

> I put a spin box linked to a cell containing an item cost of 1.50,
> because the items cost is part of a cutting test I want the user to be
[quoted text clipped - 8 lines]
> biztools's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6872
> View this thread: http://www.excelforum.com/showthread.php?threadid=524645

Signature

Dave Peterson

Reply to this Message

biztools - 21 Mar 2006 18:05 GMT

Dave, thanks a lot for the hel

Reply to this Message