CheckBox controling a ComboBox

[Dillonstar]

I am currently building a form in VB and have hit a snag.

I want to have 3 CheckBoxes in a frame that drive a specific list to be
selected from a single ComboBox. I.e. each CheckBox generates a
different and unique list from the combobox.

Any Ideas

 

[steve]

I would recommend option buttons. This way only 1 list would be supplied.

Private Sub OptionButton1_Click()
ComboBox1.RowSource = ""
ComboBox1.RowSource = "Sheet1!A1:A5"
End Sub

or

Private Sub OptionButton1_Click()
ComboBox1.RowSource = ""
ComboBox1.RowSource = "mylistname"
End Sub

set up code for each button.

 

[Dillonstar]

Thanks for the advice, does exactly what I wanted...

TVM

 

[steve]

Glad it worked!

Keep on Exceling...