|Whoops! It looks like I forgot to include the code. I can see why you are confused! Sorry...here you go...|
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address = "$F$2" Then
Application.CutCopyMode = False
This code will run whenever a change is made to the contents of cell F2.
If you need some type of code to run when other cells are changed, you'll need to be more specific.
The "target" is a cell or range of cells that, when changed, cause the Change event code to run. You could also have code that runs when a specific cell is simply selected, as well as when many other Events occur.
I should add that any code offered in a forum like this should only be a starting point. For example, you say that you are only familiar with copy/play macros. Well, here is the chance for you to broaden your knowledge. Now you know that Event macros exist - marcos that can be triggered by events that occur in the worksheet. Look them up in Excel help or use Google for more info.
Come on back if you need more help.