| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nothing selected in my list box?
Hello, I need to find out if the user has selected anything in my
multi-select1 list box, I am currently using If lbxHeadings.ListIndex = 0 Then but that is true if nothing is selected or if only the first item is selected. If I set option base1 will that allow me to distinguish between nothing selected and the first item? Is there an easier way, as option-base1 will mean a rewrite of lots of my values throughout too? Thanks Michelle |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nothing selected in my list box?
Hi.
You should use : With Sheet1.ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) Then 'code End If Next i End With HTH Daniel Hello, I need to find out if the user has selected anything in my multi-select1 list box, I am currently using If lbxHeadings.ListIndex = 0 Then but that is true if nothing is selected or if only the first item is selected. If I set option base1 will that allow me to distinguish between nothing selected and the first item? Is there an easier way, as option-base1 will mean a rewrite of lots of my values throughout too? Thanks Michelle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
| using selected data within a dropdown list to populate new list | Excel Programming | |||
| A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
| Last list item selected in a Multi-Select list box? | Excel Programming | |||
| Populating dropdown list 2 with data depending upon what was selected in list 1 | Excel Programming | |||
Linear Mode
