| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I delete 1 from the value of a cell when I press a Button.
I am trying to create a stock / ordering sheet. When I press a button I want
the stock coloumn to delete 1 from the value in the stock cell. Every time I try I get a circular refernce error. Can Anyone help. Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I delete 1 from the value of a cell when I press a Button.
You can use this Gary
Range("A1").Value = Range("A1").Value - 1 -- Regards Ron de Bruin http://www.rondebruin.nl "Gary" wrote in message ... I am trying to create a stock / ordering sheet. When I press a button I want the stock coloumn to delete 1 from the value in the stock cell. Every time I try I get a circular refernce error. Can Anyone help. Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I delete 1 from the value of a cell when I press a Button.
Thanks \ron, much appreciated
"Gary" wrote: I am trying to create a stock / ordering sheet. When I press a button I want the stock coloumn to delete 1 from the value in the stock cell. Every time I try I get a circular refernce error. Can Anyone help. Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find&press button | New Users to Excel | |||
| Is It Possible To Have... After A Button Press A Message Pops Up ? | Excel Worksheet Functions | |||
| My delete row button deletes only the cell not the row. Bug? | Excel Discussion (Misc queries) | |||
| key Press on Forms Button | Excel Programming | |||
| Proteting against a button press | Excel Programming | |||
Linear Mode
