Hi, I was wondering if there was a way to have a Macro associated with a cell. I have 20 cells that have pictures in them, and if you click on the picture, the macro activate. However, there are 20 macros, all of which are the same except for the cell address. If I could make a macro associated with a cell, I could use ActiveCell.FormulaR1C1 to directly edit that cell, and save memory.
So, is there any way to make a macro associated / part of a cell?
Okay, so I have posted an example. For each of the 20 cells in the D column (not the 6 cells in row 25) have an UpD## macro, which simply increments them. The macro associated with B1 increments B1 and moves the cursor to D25. I would like there to be only one UpD macro, and it's dependent on what cell you select. If it's possible, I'd also like the UpB1SelectD25 macro not be based in a picture.
Bookmarks