Hello,

I have a control box that has two options in the drop-down. I accomplished
to have it so that once one of the options is selected; a list of the outputs
is displayed in the excel spreadsheet. The problem is that when the other
option within the drop down is selected theres no list output. I need it to
generate a different output list for each option provided in the drop down.

What i have as a code which spits out the list for one option is :

Private Sub ComboBox1_Change()
With Me.ComboBox1.TopLeftCell
..Offset(0, 5) = "NIN"
..Offset(0, 6) = "NOUT"
..Offset(0, 7) = "IND"
..Offset(0, 8) = "TITLE"
..Offset(0, 9) = "CASE"
End With
End Sub


Any Help PLEASE ?