Instead of 12 buttons, why not just a drop down list (data validation) for
the months. Then the macro can refer to the cell.

mymonth=range("b4")
then
myval=choose(mymonth,1,2,3,4,5,6,7,8,9,10,11,12)

--
Don Guillett
SalesAid Software

"pabs " wrote in message
...
is it possible to pass a particular value with a button to a macro?

in my case I have 12 buttons (one for each month).
If the user hits a particular button I want to pass along the month
corresponding to that button to my main macro.
The main macro is always the same. it already has logic in it to
handle each month.

I could have a small macro for each button that would then call my main
macor with the corresponding month but that doesn't seem very clean or
practical.

there must be an easy way to always call the macro with a different
string as a paramater..

I'm open to any ideas here...

is there a way to get a string from a select list? in other words I
could have a list with all my months and the user would select the
desired month from the list and then hit the run button (only one
button as oppose to 12)! ..

that would be nicer but I am unsure how to that


thanks for any help

Pabs


---
Message posted from http://www.ExcelForum.com/