| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to program a cell ?
I want to program cell A1 with a symbol + and B1 with a symbol -
When I click on A1, I want A2 to increase by 5 min. When I click on B1, I want A2 to decrease by 5 min. Can someone help me ? Thanks ! If possible, can you email the EXCEL file. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to program a cell ?
Why not add a Spinner from the Forms Toolbar?
Draw the Spinner over B1 and B2 or near enough. Set it to increment by 5 when clicked up or down. Gord On Thu, 29 Mar 2012 15:59:25 +0000, acwai wrote: I want to program cell A1 with a symbol + and B1 with a symbol - When I click on A1, I want A2 to increase by 5 min. When I click on B1, I want A2 to decrease by 5 min. Can someone help me ? Thanks ! If possible, can you email the EXCEL file. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to program a cell ?
Forgot to mention..........select A2 as "linked cell".
Gord On Thu, 29 Mar 2012 17:17:34 -0700, Gord Dibben wrote: Why not add a Spinner from the Forms Toolbar? Draw the Spinner over B1 and B2 or near enough. Set it to increment by 5 when clicked up or down. Gord On Thu, 29 Mar 2012 15:59:25 +0000, acwai wrote: I want to program cell A1 with a symbol + and B1 with a symbol - When I click on A1, I want A2 to increase by 5 min. When I click on B1, I want A2 to decrease by 5 min. Can someone help me ? Thanks ! If possible, can you email the EXCEL file. |
|
#4
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Program so that clicking on a cell will copy that cell to another | Excel Programming | |||
| program a cell in excell to reference a cell below a referenced ce | Excel Programming | |||
| program cell to display any character when cell is active | Excel Programming | |||
| merging excel program with tdc finance program | Excel Programming | |||
| Program cell to delete other cell values | Excel Programming | |||
Linear Mode
