how to assign value to button and use it as variable in a macro

[luv2glyd]

I'd like to have several buttons in a sheet that have individual variables assigned to them, that are used by the same macro. To give an example, let's say I have a macro that inputs a value into cell A1 as soon as I press a button. What I'd like to do is if I press button1, cell A1 gets a 1 in it, if I press button2, if I press button3, cell A1 gets a 3 in it and so on. This is just an example, as the real code is more lengthy, but in summary what I'm after is having a single macro which gets activated by a button and uses a variable assigned to that button, rather then having a macro assigned to button1, then a separate macro assigned to button2, and so on... So in example above, value of 1 is assigned to button1, 2 to button2 and so on. Is this possible? If so, what's the simplest way to do it?

Thank you.

[xLJer]

Will this work for you?

Please Login or Register  to view this content.