how to enable different macros based on combo box selection?

[juju]

I have a spreadsheet with 2 combo boxes - Combobox 1 enables a user to specify if they want to look at the data on the sheet by week or month - it has just 2 options - "select by week" or "select by month"

The list in combobox 2 changes based on the selection in combobox1 - so if you select "select by week" , a date list by week shows up.

Combobox 2 is supposed to run a macro which updates some backend pivot tables. there are 2 types of backend pivottable - weekly tables and monthly tables.

What i am not sure about is how to get the selections in combobox 2 to run either the weekly macro or the monthly macro based on if combobox1 is set to week or month ...?

 

[mikerickson]

Like all code, it needs to be inside a proceedure. Put it inside a

Sub Test()
    Rem code goes here
End Sub

 

[juju]

Like all code, it needs to be inside a proceedure. Put it inside a

Sub Test()
    Rem code goes here
End Sub

I am ashamed! Its working - BUT, the list in box 2 is not updating to reflect the selection made in box1 ...