ComboBox HELP

rockchalk33

Board Regular
Joined
Jan 12, 2016
Messages
110
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

rockchalk33

Board Regular
Joined
Jan 12, 2016
Messages
110
PS Column A will be the rowsource and will contain the names which are found in the ComboBox or ListBox.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,551
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?
 
Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
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

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
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

Board Regular
Joined
Jan 12, 2016
Messages
110
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

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
OK. So the answer to your question is Yes for listbox. No for Combobox.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,048
Messages
5,466,253
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top