Multiple select drop down list

**boc_est1986** · 08-14-2009, 07:15 AM

I want to use a drop down list to select multiple emails to send a file to but combo boxe's dont allow multiple selections, is there any way to get a list box to drop down in the same sort of style?

**DonkeyOte** · 08-14-2009, 07:18 AM

See the ListBox control and Multi-Select property.

**boc_est1986** · 08-14-2009, 07:39 AM

i've got that working but the list box uses a scroll bar and looks messy, i'm looking to make it drop down like a combo box does

**DonkeyOte** · 08-14-2009, 08:07 AM

Not something I'm aware of using native controls I'm afraid.

On the off change you're using OL as mail client and the required addresses are stored in OL you could possibly use XL VBA to launch a new mail dialog (& attach file) and then use standard OL dialogs to select recipients ?