Retrieving name from command button on Worksheet
I'm using Excel 2000 under win2K and have several command buttons on a
worksheet and assigned the same macro to them.
In the macro I want to find out WHAT button has been clicked
(extracting a number I attached to a name to privide as parameter in a
function). I don't want to create a bunch of macro's just to identify
each command button separately.
How do I do that?
|