Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
I have a list box that I populate using the following code: Load Userform1 Userform1.varinclude.Clear For i = 1 To NV Userform1.varinclude.AddItem VarNames(i) Next i I know I can use "selected" to determine what has been selected in the list box. Is there a quick way of telling if nothing has been selected? I can set of for loop to see if each selected is false, but though there might be a quicker way. Thanks. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bill,
You could use the Listbox's change event to set a flag, but you won't be able to tell if an item is selected and then de-selected, just that an item was (at some time) selected. HTH, Bernie MS Excel MVP "Bill" wrote in message ink.net... Hello All, I have a list box that I populate using the following code: Load Userform1 Userform1.varinclude.Clear For i = 1 To NV Userform1.varinclude.AddItem VarNames(i) Next i I know I can use "selected" to determine what has been selected in the list box. Is there a quick way of telling if nothing has been selected? I can set of for loop to see if each selected is false, but though there might be a quicker way. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a multiselect drop down list | Excel Worksheet Functions | |||
List Box Multiselect Form | Excel Programming | |||
Coding with pivots and Multiselect list | Excel Programming | |||
List Box - MultiSelect | Excel Programming | |||
Multiselect list box | Excel Programming |