Choosing multiple items in a dropdown menu
 

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?

Choosing multiple items in a dropdown menu
 

See the VB Help on MultiSelect properties.

Mike F
wrote in message
ups.com...
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?

Choosing multiple items in a dropdown menu
 

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
wrote in message
ups.com...
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?

Choosing multiple items in a dropdown menu
 

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)

wrote in message
oups.com...
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
wrote in message
ups.com...
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?