Hey guys, I'm new to Excel and trying to learn some courses online. One of the assignments requires me to use 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-the price) value doesn't automatically update when I reselect the values of the independent cell (B2-the category) and the dependent cell (B3- the model). In other words I mean I reselect the value of B2 (honda) and B3 (honda xyz) but cell B6 still stays as -- Reselect criteria --(when it supposed to automatically turn to a value like $500). Please help. Thank you so much for your help!
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-the price) value doesn't automatically update when I reselect the values of the independent cell (B2-the category) and the dependent cell (B3- the model). In other words I mean I reselect the value of B2 (honda) and B3 (honda xyz) but cell B6 still stays as -- Reselect criteria --(when it supposed to automatically turn to a value like $500). Please help. Thank you so much for your help!