Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've created a form that launches a filter in Excel.
The listbox shows 8 names, but I want to still keep the option of choosing a "blank" or null value for each list. Is there a way to activate an "unclicking" the higlight in the list box or a way to add a blank row in the list box? 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 | |||
Ignoring Blank value in a drop down list | Excel Worksheet Functions | |||
auto updating list | Excel Worksheet Functions | |||
When I sort a list, How can I keep blank rows between the fields? | Excel Discussion (Misc queries) | |||
Eliminating blank cells in a list on a ROW | Excel Worksheet Functions | |||
Conditional list without blank rows | Excel Worksheet Functions |