I have created a command button1 in excel. When I clicked on that button Serial No.should come in the colulmn A1 and If I click next time it should come in A2. What is the VBA code that i should linked to the command button1? Please suggest.

The serial no.should be 1 2 3 4 ..............etc..