Home > Development, VB .Net > Excel：Drop-down List Based On Selection In Another Drop Down List

Excel：Drop-down List Based On Selection In Another Drop Down List

February 3rd, 2011 Leave a comment Go to comments

How to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box.
Example:
If Fat, Use range from C6:C7
If Skinny, Use range from D6:D7

You can direct put the IF statement in 2nd drop down validation, like

=IF(Sheet1!$A$1="Fat", Sheet1!$C$6:$C$7, Sheet1!$D$6:$D$7)

Categories: Development, VB .Net Tags: ,
  1. No comments yet.
  1. No trackbacks yet.
You must be logged in to post a comment.