Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation lists... | Excel Discussion (Misc queries) | |||
Drop down lists and macros | Excel Worksheet Functions | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
pasting into lists using macros | Excel Discussion (Misc queries) |