LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ignoring Blank value in a drop down list shail Excel Worksheet Functions 15 August 28th 06 12:39 PM
auto updating list Larry Excel Worksheet Functions 8 July 27th 06 01:59 PM
When I sort a list, How can I keep blank rows between the fields? Erin Excel Discussion (Misc queries) 5 July 26th 06 09:18 PM
Eliminating blank cells in a list on a ROW grime Excel Worksheet Functions 5 November 3rd 05 05:41 PM
Conditional list without blank rows Andrew Excel Worksheet Functions 1 June 9th 05 03:28 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"