View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dascooper dascooper is offline
external usenet poster
 
Posts: 3
Default Combo Box for a list of records

I figured out how to use data validation for this. The next step would be to
filter the list based upon the value in another field (in the same
record/row). IE, if I selected Illinois, the City colum would only list
valid cities in IL? Any suggestions?

"dascooper" wrote:

How can I create a combo box that can be used in a column of data (ie, having
a column of states and a combo box of all the states instead of typing in for
each record)