how to automatically update a dependent cell value?

%3CLINGO-SUB%20id%3D%22lingo-sub-2840489%22%20slang%3D%22en-US%22%3Ehow%20to%20automatically%20update%20a%20dependent%20cell%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2840489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHey%20guys%2C%20I'm%20new%20to%20Excel%20and%20trying%20to%20learn%20some%20courses%20online.%20One%20of%20the%20assignments%20requires%20me%20to%20use%20VBA%20code%20to%20reset%20conditional%20dop-down%20lists.%20I%20got%20that%20part%20as%20I%20followed%20the%20tutorial%20video%20using%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EPrivate%20Sub%20Worksheet_Change(ByVal%20Target%20As%20Range)%3CBR%20%2F%3EIf%20Target.Address%20%3D%20%22%24B%242%22%20Then%3CBR%20%2F%3ERange(%22B3%22)%20%3D%20%22--%20Choose%20Model%20--%22%3CBR%20%2F%3ERange(%22B6%22)%20%3D%20%22--%20Reselect%20criteria%20--%22%3CBR%20%2F%3EEnd%20If%3CBR%20%2F%3EEnd%20Sub%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%20what%20I%20didn't%20seem%20to%20get%20is%20that%20the%20dependent%20cell%20(B6)%20value%20doesn't%20automatically%20updatewhen%20I%20reselect%20the%20values%20of%20the%20independent%20cell%20(B2)%20and%20the%20dependent%20cell%20(B3).%20In%20other%20words%20I%20mean%20I%20reselect%20the%20value%20of%20B2%20and%20B3%20but%20cell%20B6%20still%20stays%20as%20--%20Reselect%20criteria%20--.%20Please%20help.%20Thank%20you%20so%20much%20for%20your%20help!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2840489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2841913%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20automatically%20update%20a%20dependent%20cell%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2841913%22%20slang%3D%22en-US%22%3EIf%20you%20have%20any%20recommendations%2C%20please%20help!%3C%2FLINGO-BODY%3E
New Contributor

Hey guys, I'm new to Excel and trying to learn and practice skills.  I used VBA code to reset conditional dop-down lists. I got that part as I followed the tutorial video using


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Range("B3") = "-- Choose Model --"
Range("B6") = "-- Reselect criteria --"
End If
End Sub

 

But what I didn't seem to get is that the dependent cell (B6) value doesn't automatically update when I reselect the values of the independent cell (B2) and the dependent cell (B3). In other words I mean I reselect the value of B2 and B3 but cell B6 still stays as -- Reselect criteria --. Please help. Thank you so much for your help! 

1 Reply
If you have any recommendations, please help!