Command Button

[wjd01]

Hello,

I hope someone can help with my question.
Is it possible to have one macro, that when activated by a
command button, make the cell beneath the command button
active? For example, I would have 10 command buttons on
cells C11 thru C20 (one over each cell). If any one of
these are clicked, the cell beneath is now the active
cell.
I'm trying to avoid having 10 individual macros assigned
to the buttons (one per button). I just wasn't sure if
one simple macro could be written that takes into account
the buttons position for setting the active cell.

Thanks in advance,
wjd01

 

[Jim Rech]

If you use buttons from the Forms toolbar they can all have the same macro:

ActiveSheet.Buttons(Application.Caller).TopLeftCell.Select

If you're using the Control Toolbox command button it may be harder...

 

[wjd01]

Thanks Jim. This worked perfectly.

wjd01