Macro based on Focus
Posted by Jason Hendry on October 12, 2001 9:20 AM
Is it possible to write a macro so that when the focus (cursor location) is moved to a particular cell, a value changes in another cell?
My sheet calculates workdays to completion for a number of tasks. I can display a grid of tasks and their timeframes. It would be of great help if I could make it so that the individual selects the type of cell noting the type of work being done and the time info for that type of work would automatically appear in the cell used for the formula.