|The A you probably changed was in the green Comment line, which won't do anything.|
What you need to do is change the 1 to a 9 in the actual instruction line.
If Target.Column = 9 Then
Column A is 1, B is 2, etc.
Once you edit that line, you should be able to enter your values in Column I and have them change.
Eventually, the file will need to be saved as a .xlsm to retain the macro, but it doesn't have to be saved in order for it to work.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.