Form buttons
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 |
Form buttons
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" 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 |
Form buttons
Thanks Jim, That sounds a better option!
"Jim Cone" wrote in message ... 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" 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 |
All times are GMT +1. The time now is 10:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com