Form buttons

[Homer]

Hi,

I've added some buttons on a spreadsheet to increment and decrement
a number contained in a cell. The trouble is, I need the number to be able
to be positive or negative. The options on the setup tab only allow for 0
upwards. Is there a way to decrement below 0?

I figure I could start at say A1=500 and make another cell ie A2=A1-500
but this would make things overly complex. I wondered if the range can be
set more easily?

Thanks,

Nick

 

[Jim Cone]

That's the way to do it. However,
you don't need to enter a value in the linked cell.
Instead, set the Spin Button maximum value to twice the
expected maximum...1000 and set the initial value to 500.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Homer" <[email protected]>
wrote in message
Hi,
I've added some buttons on a spreadsheet to increment and decrement
a number contained in a cell. The trouble is, I need the number to be able
to be positive or negative. The options on the setup tab only allow for 0
upwards. Is there a way to decrement below 0?
I figure I could start at say A1=500 and make another cell ie A2=A1-500
but this would make things overly complex. I wondered if the range can be
set more easily?
Thanks,
Nick

 

[Homer]

Thanks Jim, That sounds a better option!