View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bob bob is offline
external usenet poster
 
Posts: 52
Default Controling the list in a combo box

I'm trying to create a combo box where the list will vary
based upon a state that is chosen. Currently, I have a
column setup as my list that will show a blank line for an
invalid selection. However, this means I have 100+ blanks
lines in my dropdown list. I want to get rid of the blank
lines and have tried checking the ignore blanks box in the
validation screen. Ay help would be appreciated.