Linking several combo boxes to a macro in excel?

Question

I'm creating an application in excel where I would like to link multiple combo boxes to different macros.

This is an application that pulls monthly and weekly reports on defferent vendors.

One box has a list of vendors. Then, next to it there are combo boxes that let you pick certain months to view reports. The user has three options, one box for looking at a single month, two boxes that select one month through another month, and two boxes that pick two months to compare. Next to each of these options is an option button so that the user can choose what kind of report to view. After all of that is a command button that would start the macro.

This is a bit over my head and would appreciate any advice that would help me write the code for this.

Answer 1

Well, you either want to write a macro for each combo box or you can use Call or Run to call a particular macro that you want to run.

Without really seeing all of the data and what you truly want to do, it would be hard for someone to write a macro that does all of that, because that is going to be a complicated macro to write, although it can be done somewhat easily if the programmer knows all of the info like where the data is coming from, etc.

Pretty much all of your code should be listed under the command button. The combo boxes and option buttons most likely will not have hardly any code, because really all you are doing is using them to get inputs from the user. The macro from the Command Button can gather all of those inputs. So you should just need one big macro under the command button's Click procedure.