![]() |
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