Format a cell or column to insert instead of overwrite

Hello,

I was wondering if there is a code to help with this. I am trying to make an inventory type spreadsheet that allows for users to just open it and scan bar codes in. When they scan the bar code into a column, i don't want to it overwrite the previous values in the column, since my other inventory codes rely on a count in that column. Is there a way to make sure that when values are added to the top of the column that it does not overwrite what is already there and just adds to the top?

Okay, that is what I was looking for. The scanner just adds the values like typing it into the cell, so hopefully that will not be a problem.

I am fairly new to VBA though, and I was wondering if you could help me decipher what values to change in this code to have it work for me. Thank you for you help.

Never mind, I figured out that I just need to change the 1. But I have two other unexpected problems with it.

1. It is adding shading behind the values once they are added that I would like to get rid of

2. After entering the value, I would like the input to stay in the first box that the values were being entered into (which I did not previously say) so that values can just be added to the list.