Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I havea form that I have created with two list boxes. The macros
launches a filter. How do I create a property in the list box that would allow a user to "deselect" the list box. Right now, once the user clicks in the box, a name is highlighted and the only option is the select another name. You can't click on a name again and deselect it. My code is: Private Sub CommandButton1_Click() vEmpSups = frmSupervisors.lstEmpSups.Value vRoutesups = frmSupervisors.LstRouteSups.Value Sheets("DispatchSheet").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:=vEmpSups Selection.AutoFilter Field:=2, Criteria1:=vRoutesups End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formatting the list items for ComboBox created using Forms | Excel Discussion (Misc queries) | |||
data validation--multiple dependent list | Excel Discussion (Misc queries) | |||
Check 2 different list get associated value from a column | Excel Worksheet Functions | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |