ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List Box - Blank Row (https://www.excelbanter.com/excel-discussion-misc-queries/103613-list-box-blank-row.html)

Nimish

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



All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com