Tech Support Forum banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
2 Posts
Discussion Starter · #1 · (Edited)
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 = "$C$2" Then
Range("C3") = "-- Choose Discription --"
Range("C10") = "< Reselect criteria >"

End If
End Sub


But what I didn't seem to get is that the dependent cell (C10) value doesn't automatically updatewhen I reselect the values of the independent cell (C2) and the dependent cell (C3). In other words I mean I reselect the value of C2 and C3 but cell C10 still stays as < Reselect criteria >. Please help. Thank you so much for your help!
 

·
Team Manager, Microsoft Support
Joined
·
29,746 Posts
From our RULES: You may not ask for assistance with homework assignments, projects or book reports for school college or university
Thread Closed
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top