VBA Help need for Time sheet update besed on UserForm input.

Hi Folks

Please help me to update the time sheet data based on userform input? I have attached a file of what I'm trying to accomplish. Thanks in advance for your expertise!


Joshi

Hi Folks,
Please help me.!

Thanks in advance.

Joshi

Hello Joshi,

What is your comfort level/experience with VBA? I think I can help you but I want you to understand the solution not just me telling you do this/do that. If in the future you need to make some modifications for new empoloyes/change employees I want you to understand it.

Let me know!

Hi Bmoe,
Thanks for your reply. I have only basic knowledge about VBA. But i am able to modify if you are developed something. Thanks in advance,

Joshi

Hey now, I'm not developing anything! You are! (This is a decent sized undertaking)

So first, to modify the cells you need to write some code in your go button on your userform. The first thing is you need to add a date/time picker for the time. Right now all you have is dates. I would also go into the object property sheets and change the names of those so you know what they are like the "Date IN" dropdown should be dtpDateIn, "Time IN" might be named dtpTimeIn. That way when you are writing the code it is easier for you to remember and to read later. Once you get those straightened out. You need to write some code that will find the cell its supposed to update.

First off you need to find the row.
For x = row number of first employee to row number of last employee
if activesheet.range("Column Letter of employees" & x).value = the employee in your form dropdown Then
...
...
This will allow you to find your row.

Then do the same to find the date/and IN/OUT column.

Marry that up with the value you found for row and use the cells(column, row).value to set the time from the time picker and you should have it.