VBA Userform Information Autopopulate Specific Cells then Loop?

[HazMattTeam]

Hi Everyone!

EXTREMELY new to doing any macros and VBA coding within excel but have found these forums particularly helpful and have been able to tweak many to fit my needs without learning exactly how anything works...... so now I need some help since I cant find a similar situation.

I have a userform with 36 text boxes that I have gotten each to fill in a corresponding cell in excel once the OK button is clicked.

I am trying to figure the coding for the next time the userform is filled it will fill the new information in the same column but +5 rows down. and so on and so fourth. I have a note on the userform that all areas must be filled in thinking that it would be able to detect values and move on but idk if that is neccessary.

To explain I am making a timesheet that is kind of dummy proof for supervisors where they will click a button that opens a userform they fill in names, and hours for specific days then hit ok and repeat for the next employee. This document is then made into a .PDF and sent into the office for timecards. Since I am SUPER new to this please use color coding for areas where I need to fill in information from my spreadsheet.

Please Login or Register  to view this content.

THIS IS MY CODE SO FAR.... sorry if its terrible but its what I could piece together from other threads and it works....... just needs that extra step... Also, this worksheet will eventually be copied and renamed Week Ending 7-27-19 etc. any way to write this so it will work on the next sheet??


Thanks everyone!!! Cheers!

-Matt

[HazMattTeam]

just working saturdays love it!

[Mumps1]

The code can be shortened to this:

Please Login or Register  to view this content.

Regarding the other questions, it would be easier to help if you could post a copy of your file (de-sensitized if necessary).

[HazMattTeam]

Thanks, There was an error when I attempted that. How would i go about posting a copy? I dont see an add attachment spot?

[Mumps1]

Click the "Go Advanced" button. Then scroll down a bit and click "Manage Attachments".

[HazMattTeam]

Ok. figured out your instructions.. by the way thanks a ton. Really appreciate everything

[HazMattTeam]

Ok back in the hotel from the jobsite ready when you are

[Mumps1]

Ok back in the hotel from the jobsite ready when you are

I’m away from home right now. I won’t be able to respond until tomorrow.

[AliGW]

Administrative Note:

HazMattTeam - we don't expect you to bump threads more than once in 24 hours - it had been less than an hour since you last posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[Mumps1]

Try:

Please Login or Register  to view this content.

[HazMattTeam]

Thanks Mumps!

Definitely works for the current worksheet!
The only part where it doesn't work is when I start adding new worksheets in the future (and I forgot the text box for AREA.Value in (e,8) i just saw this morning :S).
Basically we just make a copy of 7-20-19 and rename it 7-27-19. When I did this the userform continued to push the data back into 7-20-19.
Is there a way to rewrite:

Please Login or Register  to view this content.

so that it is the currently active sheet where the userform button was clicked?

Much love for the help,
Matt

[Mumps1]

Try:

Please Login or Register  to view this content.

[HazMattTeam]

SOLVED!!!! thank you!

[Mumps1]

You are very welcome.

[HazMattTeam]

OOOOO NOOOO!!!!

I messed up the input somewhere..... and like a dummy i forgot to save...
everything shifted up two cells for some reason!!!

[Mumps1]

Enter the dates in J5:P5 so those cells are not blank.

[HazMattTeam]

SOLVED x2