userform listbox that lists data based on radio button selections

**Shogun** · 03-14-2009, 07:06 AM

Hi All,

Just registered to the forum and was hoping someone may be able to provide assistance.

I have a worksheet (attached) that lists various clients in columan C. Column E lists whether each of the clients listed in Column C are 'Existing Business' or 'New Business'.

I require a user form that has three radio buttons (one to select 'New Business', another for 'Existing Business' & one for 'All').

When Selecting a radio button, (e.g. 'Existing Business'), I need all clients listed in Column C of the worksheet that also have 'Existing Business' in Column E to be listed in a ListBox on the UserForm (with the second radio button allowing the text box to list 'New Business' and the third to list both Existing and New).

My experience with Visual Basic is minimal so any assistance would be very much appreciated.

Thanks...

**royUK** · 03-14-2009, 07:21 AM

I have an example of a userform with a ListBox that has comboboxes to select criteria to filter the data by. Filter ListBox should be easy to adapt to your requirements.

**Shogun** · 03-14-2009, 10:58 AM

Thanks for your response, really appreciate your assistance.

I've taken a quick look at your template which certainly provides something I can work off.

Thanks again

**royUK** · 03-14-2009, 11:35 AM

Post back if you need help. I have adapted it for you, but it will help you if you have a go yourself

**jbeeball** · 05-09-2012, 10:46 AM

The file is no longer available when following the link above.
I have a similar question. Could you please look at my help post?
http://www.excelforum.com/excel-prog...selection.html