Oct 12 2021 10:03 PM - edited Oct 13 2021 06:53 AM
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!
Oct 13 2021 06:25 AM