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 |
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) |