Forms: Listbox question

teebruin · May 8th, 2002, 02:44 PM

I'm trying to design a form. What I would like to do is have 2 option buttons and a listbox. I want to populate the listbox based upon which option button is selected. If they choose option 1, I want to show one set of data in the listbox, but if they choose option 2, I want to show a different set of data.

Can someone get me started on how to accomplish this?

Thanks in advance for any help.

Damon Ostrander · May 8th, 2002, 03:57 PM

Hi teebruin,

Assuming that you want to fill your listbox from two different worksheet ranges, you can simply use the optionbuttons' click events to reassign the RowSource property of the Listbox:

Private Sub OptionButton1_Click()
ListBox1.RowSource = "a1:a10"
End Sub

Private Sub OptionButton2_Click()
ListBox1.RowSource = "b1:b10"
End Sub

teebruin · May 8th, 2002, 05:46 PM

Thank you very much. This is exactly what I was looking for. I was focused on doing something to the listbox, and didn't even think about the option buttons.

Again, thanks.

May 8th, 2002, 03:57 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi teebruin, Assuming that you want to fill your listbox from two different worksheet ranges, you can simply use the optionbuttons' click events to reassign the RowSource property of the Listbox: Private Sub OptionButton1_Click() ListBox1.RowSource = "a1:a10" End Sub Private Sub OptionButton2_Click() ListBox1.RowSource = "b1:b10" End Sub __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 02:44 PM	#1
teebruin New Member Join Date: Mar 2002 Posts: 38	I'm trying to design a form. What I would like to do is have 2 option buttons and a listbox. I want to populate the listbox based upon which option button is selected. If they choose option 1, I want to show one set of data in the listbox, but if they choose option 2, I want to show a different set of data. Can someone get me started on how to accomplish this? Thanks in advance for any help.

May 8th, 2002, 05:46 PM	#3
teebruin New Member Join Date: Mar 2002 Posts: 38	Thank you very much. This is exactly what I was looking for. I was focused on doing something to the listbox, and didn't even think about the option buttons. Again, thanks.