Macros and validation lists
Hi,
I have a data validation list defined in an excel
spreadsheet. I am trying to run a small macro that ensures
that if a particular list definition is active in the
respective cell(say AAA) then other cells (3 in total) are
set to zero ...
I am not at all familiar with macros - just trying to find
my feet. What I have presently is:
Range("D4").Select
If Range("D4").Value = "AAA" Then
ActiveCell.FormulaR1C1 = "0"
Range("E4").Select
ActiveCell.FormulaR1C1 = "0"
Range("G4").Select
ActiveCell.FormulaR1C1 = "0"
End If
End Sub
However it is not recognising the validation list? I
suspect I am using wrong programming statements. Would
apprecitae if someone could get me off the ground ...
Many thanks,
Don-
|