Using Command buttons to enter value in a cell, then move on to the next cell and do the same

[mf6605]

I have some experience creating Input boxes and message boxes and such but I can't seem to figure out how to deal with user forms that have custom command buttons. I'm not the greatest at explaining my thought process and I'm still kind of a noob at this so bear with me lol.

Basically I created a user form with three command buttons. Each command button enters a specific value in the cell. For Example Button1 enters a 1, Button 2 enters a 2 and Button 3 enters a 3. I figured out how to do that however, it doesn't work with the big picture I have in mind as this is only attached to one specific cell.

The big picture is the following...

For Example, what I want is for the form I created to pop up (Which I was able to do) then when I select "Button2" it enters the value "2" into cell "A1". Then right after I want the exact same form to pop up but this time I want the value of what ever button I select to be entered into cell "A3". Then keep it going for Cell A4,A5,A6, and so on.

How should I code this macro as well as the three command buttons to fit this big picture?

Hopefully you some someone can make sense of this lol

Thank you

 

[EXCEL MAX]

Hello mf6605,
you can do that in different ways, depending what you are doing,
but the most common way is counting cells from bottom to the top until meeting first populated cell,
then add one more cell.
Insert this code line before insert value to the cell.
Do it in each command button.

    With ActiveSheet
        .Range("A" & Cells(Rows.Count, "A").End(xlUp).Row + 1).Activate
    End With