Drop down list in user form

[srinidhi]

Hi, Happy new year to all of you.

I am beginner in VBA, I need help from the experts to create this user form.

The user form should appear in the userform tab
The names from colum A should be the drop down list in the userform name field
In the userform only the current weeks dates should appear.

The file is attached for reference

It is for entering the employee timesheet.

 

[Luke M]

Not sure if you wanted a VBA user form as you mentioned a sheet, but for a basic one, let's keep it in a sheet. How does the attached look?

 

[srinidhi]

Hi Luke, Thanks for the excel, what I was looking out is an user form where the employees select their names from the drop down list & besides the dates they enter the numbers of hours worked & press save & the data is saved in the main sheet where I have put the names & dates. Its a VBA user form to input the numbers of hours worked against the name & date.

 

[Somendra Misra]

Hi Srinidhi,

See the attached file. I had use Luke file and developed the userform.

See if this meets your requirement.

Regards,

 

[srinidhi]

Thanks, Somendra,

Can we have the dates in the user form instead of drop down. I don't need the current weeks date, all the dates in my sheet should appear in the user form.

 

[Somendra Misra]

Thanks, Somendra,

Can we have the dates in the user form instead of drop down. I don't need the current weeks date, all the dates in my sheet should appear in the user form.

So that means all the dates in the header of your table should appear?

Regards,

 

[srinidhi]

yes, you got it right, it will be basically for a week or 15 days.

 

[Somendra Misra]

yes, you got it right, it will be basically for a week or 15 days.

Just try this on sheet3 in the range C2:C8 @Luke M had got the dates with formula, replaces those dates with the dates of your choice , than change WeekDate named range with below formula:

=Sheet3!$C$2:INDEX(Sheet3!$C$2:$C$150,COUNTA(Sheet3!$C$2:$C$150))

Regards,

 

[srinidhi]

Thanks somendra will try it out.