VBA to automatically move command button to another cell after being clicked on

Hello,

I'm creating a command button and placing it into a cell in the first column to automatically insert data into that cell. After the command button is clicked on, I would like for it to populate that cell and then have the command button move down to the first empty cell in that column. Also, if the last cell that was filled by the command button is deleted, I would like for the command button to move back to that cell which is now empty. I hope that made sense. Is it possible to create a worksheet change event for this? Thanks in advance.

It would be much easier if you supplied a sample workbook that showed what you have and explained the results you wanted.

You can attach a sample file by clicking on "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area.