Sheldon,

In a word, no. No worksheet thing comes to mind that works as a function of the active cell.
You might want to use some radio buttons or a list box (Forms Toobar or Control Toolbox)
instead of cell selection.  They'll let you click to make such choices, and you can use
formulas that will change a cell value as you wish.