Dropdown Lists Connecting to Other Dropdown Lists

Hi All,

I need to connect one drop down menu to another.  Hoping someone can assist here?

For example, the first question in the spreadsheet (to the end user) is 'What would you like to review?'.  The first dropdown presents two listings - 'Monthly Performance' and 'Weekly Performance'.

If the user selects, 'Monthly Performance', I want the second dropdown listing (located in the row beneath) to present the relevant options - i.e. June, July, August etc.

If the user selects, 'Weekly Performance', I want the user to only see weekly periods i.e. 01/07/08-08/07/08 etc in the second dropdown menu.

Would really appreciate some help on this!

Cheers,

Ashley 

Ashley

There could be more questions than answers here, but if you are using Combo Boxes from the ActiveX 'controls' collection then I would set up three ranges, called say months, weeks and select (on another hidden sheet would be fine, although I show them for illustration on the same sheet). Set the first combo box's ListFillRange to 'Select' (no quotes) and then use the 1st combo box's change event to set the ListFillrange of the 2nd. Using code like this

Option Explicit

Private Sub ComboBox1_Change()
If Me.ComboBox1.Value = "Months" Then
    Me.ComboBox2.ListFillRange = "Months"
Else
    Me.ComboBox2.ListFillRange = "Weeks"
End If
End Sub

 Here are images of the two selections

 For a Data Validation solution (no VBA), try: http://www.dailydoseofexcel.com/archives/2004/05/11/conditional-data-validation/)

All explained here http://www.contextures.com/xlDataVal02.html

 Grateful thanks to everyone for the quick responses. I have implemented your suggestions and i'm happy to say it works very well...