Every time the button is pressed output the values row below.

[rebeila]

Hello!

I have a VBA code that consists of some msgboxes and input boxes. Basically when you press the button and the macro runs the values are inserted on different worksheets. Instead of having many buttons, I want one button that will have the same code but insert one row below.

Any Ideas_

 

[rebeila]

What do you mean it does not work?
Do you get a message box pop-up?
I want you to tell me exactly what it returns each time when you run the code twice.

If you are not getting any Message Box at all, then you probably aren't running the right code!
You should be getting either a Message Box or an error. If you get an error, please tell me what it says, and hit the "Debug" button and tell me which line of code it highlights.

The code MsgBox Next row just pops us the msg box saying 5 that is it and then it proceeds to show me other msg boxes.
the first time i run it in inserts in row 5, and the second time in the same row. That being said it acknowledges only the second (most recent input)

 

[Joe4]

Ah, I see the issue! Minor update needed.

Change this line:

nextRow = Cells(ws.Rows.Count, "C").End(xlUp).Row + 1

to this:

nextRow = ws.Cells(ws.Rows.Count, "C").End(xlUp).Row + 1

 

[rebeila]

Ah, I see the issue! Minor update needed.

Change this line:

nextRow = Cells(ws.Rows.Count, "C").End(xlUp).Row + 1

to this:

nextRow = ws.Cells(ws.Rows.Count, "C").End(xlUp).Row + 1

Yesss!!! Thank you!

 

[Joe4]

You are welcome.