Thread: Drop down box list based on response to another drop down box
View Single Post
 
Old 04-11-2018, 08:49 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
I would use VBA in the WorkSheet_Change event for this.

Right click the sheet tab and select View Code.
Hopefully I've commented things enough for you to follow.

PS: are you actually using Excel 2003 ?
Attached Files
File Type: xls Forum example_v2.xls (40.5 KB, 13 views)
Reply With Quote