Choosing multiple items in a dropdown menu

's Computer Specifications

I am putting together a macro - which may require more than one entry
from a user.

Is there anyway to grab multiple (more than one) entry from the
pulldown menu?

's Computer Specifications

See the VB Help on MultiSelect properties.

Mike F
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am putting together a macro - which may require more than one entry
> from a user.
>
> Is there anyway to grab multiple (more than one) entry from the
> pulldown menu?
>

's Computer Specifications

thanks...multiselect seems to do the trick.

However, is there anyway to actually count the number of items
selected?

The .listcount property returns the total number of elements in the
list, as opposed to the number of elements that the user has selected.

I haven't quite worked out how to count the number of elements selected

Mike Fogleman wrote:
> See the VB Help on MultiSelect properties.
>
> Mike F
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I am putting together a macro - which may require more than one entry
> > from a user.
> >
> > Is there anyway to grab multiple (more than one) entry from the
> > pulldown menu?
> >

's Computer Specifications

With Me.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
cnt = cnt + 1
End If
Next i
End With

Msgbox cnt

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> thanks...multiselect seems to do the trick.
>
> However, is there anyway to actually count the number of items
> selected?
>
> The .listcount property returns the total number of elements in the
> list, as opposed to the number of elements that the user has selected.
>
> I haven't quite worked out how to count the number of elements selected
>
>
> Mike Fogleman wrote:
> > See the VB Help on MultiSelect properties.
> >
> > Mike F
> > <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > >I am putting together a macro - which may require more than one entry
> > > from a user.
> > >
> > > Is there anyway to grab multiple (more than one) entry from the
> > > pulldown menu?
> > >
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Choosing multiple items in a drop down list	=?Utf-8?B?U2hhZA==?=	Microsoft Excel Misc	9	7th Jul 2008 06:38 PM
Choosing Multiple items from Data Validation Lists	Alex	Microsoft Excel Programming	2	29th Apr 2008 02:39 PM
How to show dropdown list of menu items just like click on Parent menu by writing code.	Sakharam Phapale	Microsoft VB .NET	1	8th Jan 2005 12:39 PM
How to show dropdown list of menu items just like click on Parent menu by writing code	Sakharam Phapale	Microsoft C# .NET	1	7th Jan 2005 03:47 PM
choosing multiple items from a combo/field list box	jim jackle	Microsoft Access Form Coding	2	19th Apr 2004 03:43 AM