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
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