ComboBox HELP

[rockchalk33]

Hey all,

I have two questions...

1.) Is it possible to select multiple choices within a ComboBox? Is it possible to select multiple choices within a ListBox? If so, how?

2.) Assuming it is possible to make multiple selections, I have a list of names in Column A, a list of their respective addresses in Column B, and a respective comment in Column C. If I wish to create a For-Each-Next loop to print a person's name with that person's address directly below and then that person's comment directly below that, per one printed page. How can I set this up? Or is it even possible to do?

Thanks,

Devin

 

[rockchalk33]

PS Column A will be the rowsource and will contain the names which are found in the ComboBox or ListBox.

 

[mikerickson]

ComboBoxes do not accept multiple selection.
ListBoxes have a muliSelect property that can be set as desired.

What kind of ListBox are you talking about ActiveX, Forms menu or on a userform?

 

[My Aswer Is This]

It is possible to select multiple items in a listbox but not a Combobox.
In the properties box for the listbox choose Mutiselect.

And you need the listbox so you can choose which people to send a letter to is that the reason for the listbox

And in what cells do we want these values entered into for printing?

 

[My Aswer Is This]

If you have a list of names in column "A" and a list of addresses in column "B" and comments in column "C".

I see no reason why you need a listbox.

If you want to choose which Names to send a letter to I would suggest you use column "D" and put a "X" for example in column "D" for every person you want to send a letter to. Then a For loop would look in column "D" for a "X" and then enter the values from column A,B and C into the proper cells in your sheet.
At the end of the script we could clear all the "X" in column "D" and are now ready for next time.

 

[rockchalk33]

I'm using a ListBox that's inside a UserForm. The description I gave of what I need done is a generalization.

 

[My Aswer Is This]

OK. So the answer to your question is Yes for listbox. No for Combobox.