You could use a ComboBox attached to a list in a worksheet
representing the months. if you want to include the year,
the year could be centralised and the months can include
the year by using a formula. eg. 2004 in cell A1. The list
running down could include eg. "Jan-"&$A$1. The month is
selected in the combobox. That value can be passed to the
main macro by picking it up as a variable.

eg.
Dim vMonth as variant

vMonth = Userform1.ComboBox.Value

vMonth can be used by your coding.

-----Original 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/

.