Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to the cell value with a macro
I would like to select a cell with a product code (let's say cell B6 contains
Part #ABC). I would like to activate that cell, click on a button to run a macro to change the quantity (lets say quantitiy is in cell A6.) If A6 is currently 0, a click would change it to 1. if it is 2, a click would change it to 3. On a sheet with many product numbers, the macro would start at the active cell, jumpone column to the left, and "1" and return to the cell to the right. I know this is possible, but can not seem to get there. Thanks in advance for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for adding text from one cell to another cell | Excel Programming | |||
Adding a Function to a cell when inserting a row from a macro | Excel Worksheet Functions | |||
adding a macro to a cell | Excel Programming | |||
adding cell data into a macro to allow specified information filte | Excel Programming | |||
adding a line at the end of a macro to name the cell | Excel Programming |