Hey i have Created this Easy Macro-

Sub testmacro()
'
' testmacro Macro
' A Cell adds info to other cells
'
Range("A1").Select
ActiveCell.FormulaR1C1 = "1"
Range("B1").Select
ActiveCell.FormulaR1C1 = "YES"
Range("C1").Select
ActiveCell.FormulaR1C1 = "NO"
Range("D1").Select
ActiveCell.FormulaR1C1 = "NO"
Range("E1").Select
ActiveCell.FormulaR1C1 = "YES"
Range("A1").Select
End Sub


Now this Macro is a Button which i dont want. I want it so when i ente
"1" into the "A" cell it adds the YES-NO-NO-YES into the other cell
shown above. Any help people? Remember i dont want a button just cod
that works when enter "1" in cell A. Thank

--
joelbeveridg
-----------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...fo&userid=3704
View this thread: http://www.excelforum.com/showthread.php?threadid=56772