Forum Discussion
Some Excel help - Data validation using name ranges - force option if "False"
can mark this as resolved.. had to use a VBA script which is something i just learned today
for anyone it may potentially help who googled and found this however I've added what I used above
you go into VBA (Alt+F11), choose the worksheet you want
click the "change" option on the right side
and add the code below:
If Target.Address = "$C$4" Then
Range("E28").Value = "Please Select..."End If
(change the cell values to match the ones you need..)
can mark this as resolved.. had to use a VBA script which is something i just learned today
for anyone it may potentially help who googled and found this however I've added what I used above
you go into VBA (Alt+F11), choose the worksheet you want
click the "change" option on the right side
and add the code below:
If Target.Address = "$C$4" Then
Range("E28").Value = "Please Select..."
End If
(change the cell values to match the ones you need..)
Agreed, a VBA solution responding to an event will do it!
