VBA Userform Information Autopopulate Specific Cells then Loop?

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

just working saturdays love it!

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

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

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

Originally Posted by HazMattTeam

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.

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.

Try:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

You are very welcome.

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