| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font on dropdown menu items | Excel Discussion (Misc queries) | |||
| Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
| select multiple items from a dropdown list | Excel Worksheet Functions | |||
| Reference Dropdown Menu Items in Macro | Excel Programming | |||
| How Do I Reference Individual Dropdown Menu Items in VBA? | Excel Programming | |||
Linear Mode
