| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiselect listbox
Good Day Group,
What syntax to use to state that a MultiSelect Listbox has no selection? To be used in the context: If ListBox1 .....no selection.... Then etc... Brgds CG Rosén |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiselect listbox
Try this
N = 0 For i = 0 To Userform1.ListBox1.ListCount - 1 If Userform1.ListBox1.Selected(i) = True Then N = N + 1 End If Next i If N = 0 Then MsgBox "no selection" -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "CG Rosén" wrote in message ... Good Day Group, What syntax to use to state that a MultiSelect Listbox has no selection? To be used in the context: If ListBox1 .....no selection.... Then etc... Brgds CG Rosén |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiselect listbox
Listbox1.ListIndex = -1
"CG Rosén" wrote in message ... Good Day Group, What syntax to use to state that a MultiSelect Listbox has no selection? To be used in the context: If ListBox1 .....no selection.... Then etc... Brgds CG Rosén |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a multiselect drop down list | Excel Worksheet Functions | |||
| Multiselect Validation (dropdown) | Excel Discussion (Misc queries) | |||
| Multiselect Listbox use | Excel Discussion (Misc queries) | |||
| Multiselect Boxes | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Linear Mode
