CheckBox controling a ComboBox
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

CheckBox controling a ComboBox
 

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.
--
sb
"Dillonstar" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

CheckBox controling a ComboBox
 

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

TVM



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

CheckBox controling a ComboBox
 

Glad it worked!

Keep on Exceling...

--
sb
"Dillonstar" wrote in message
...
Thanks for the advice, does exactly what I wanted...

TVM



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/