View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nimish Nimish is offline
external usenet poster
 
Posts: 29
Default List Box - Blank Row

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