View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Dependent (linked) combo boxes

See Debra's excellent site:

http://www.contextures.com/xlDataVal13.html

"shapiro" wrote:

I have a list of states (New York, New Jersey, Los Angeles), and a list of
cities. How can I make that when the user selects NY in one combo box, the
other dependent combo box shows only cities from NY (Brooklyn,Bronx,Queens),
and also for New Jersey (NJ) (Newark,Trenton), etc. ?