Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
I need a form with 5 buttons that correspond with values 1-5 | Excel Discussion (Misc queries) | |||
Add buttons in a form from a datasource | Excel Discussion (Misc queries) |