Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
evnet code, checking for entry
i would like to write a view code that if someone edits a formula in column
AC, the macro copies that formula to 3 different cells on that line. assumptios: column AC is called "tot_dollars" currently cell AC10= ac11+ac12. lets say the user edits this formula to ac10=ac11+ac13. i want the macro to automatically recognize that the user modified the formula and to copy/pastespecial/formulas that new formula to three different cells on that line (ad10, bb10 and cc10) help? I did start with this sentence but ran into trouble when i deleted a row as it triggered the event. technically i didn't enter or modify anything in "Tot dollars" but by deleting it it considers it an event? If Intersect(Target, Range("tot_dollars")) Is Nothing Then exit sub thanks in advanace, Tami |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking and Unchecking CheckBoxes in code | Excel Discussion (Misc queries) | |||
Color Code Date Checking | Excel Worksheet Functions | |||
Checking & Forcing Data Entry in Cells | Excel Discussion (Misc queries) | |||
Checking if a cell entry is correct before adding it to another | Excel Worksheet Functions | |||
zip code entry | Excel Worksheet Functions |