Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing value with button to macros
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros button | Excel Discussion (Misc queries) | |||
Macros to Button | Excel Discussion (Misc queries) | |||
Check Box and Button Macros | New Users to Excel | |||
Two Macros under One command button | Excel Discussion (Misc queries) | |||
1 button for 2 macros | Excel Discussion (Misc queries) |