Name Selection in a userform, To create a Signing In Sheet.

**Sean Gillan** · 07-14-2014, 05:15 PM

Hi there,

I am creating a yearly rota that will produce a signing in sheet on a day and night basis. Im using a userform to pick the... Department, Operators name, Time In & Time Out.

The Problem I have is that the ComboBox in my UserForm for selecting the operators name shows every operator in the rota, where as I would like the Combobox in my user form to only show the operators that are on shift that day/night. To reduce the chance of selecting an operator that isnt even on shift that day.

I would also like it to subtract the names after the have been selected. to reduce the chance of entering the same name twice in the same sheet.

This is my Rota
Capture 1.JPG

This is my userform
Capture 2.JPG

This is My Sining in Sheet
Capture 3.jpg

I'm new at this, I hope I've given enough information to explain what im wanting to atcheave.

Can anyone help me please!!!

**Tinbendr** · 07-16-2014, 01:03 PM

I hope I've given enough information to explain what I'm wanting to achieve.

It's going to be difficult to offer suggestions without a worksheet and some walk-throughs of how you operate the userform.

**Sean Gillan** · 07-16-2014, 02:54 PM

My other post has the file attached!!!

**Sean Gillan** · 07-16-2014, 02:57 PM

Ive attached it again, as i siad im new at this ive never used a forum before.

**Tinbendr** · 07-16-2014, 04:28 PM

And could you tell us a little about the 'printout'? Does each dept get one. Are there multiple depts on a sheet? Is this just for one day, or multiple days? Multiple shifts?

While it may make sense to you, I don't deal with schedules and so, it's all kinda vague to me.

**Sean Gillan** · 07-16-2014, 06:01 PM

From the userform, you can select the department through a combo box same with the job tital for up to 28 staff, for one shift, the problem i have is the combo box that selects the operators name take everyones name from a list on the setup page.

Causing it to show people that are not on shift that specific day, i woul like to make a second list that would only show the names that are on shift that day, making it less likely to make a mistake, also as you select a name it be subtacted from the list so not to be entered twice by mistake.

There will only be one sheet printed per shift and multiple departments will all sign it.

We are a contract company so this will be used to total the hours each shift to be charged to the customer.

I hope this helps, if not please ask as many qustions as you like.

Thanks for your feed back ill try to add more detail to me posts from now on.

**Tinbendr** · 07-17-2014, 12:53 PM

While I've worked out your userform, I did not flush out the change events with EVERY combobox.

I did, however, recreate a simplified userform for you to try.

HTH.

**Sean Gillan** · 07-20-2014, 03:48 PM

Hi, i had a look at the new user form, its not what im looking for on this project but it will be perfect for another project im working on.

Thanks for that...

**Tinbendr** · 07-21-2014, 09:34 AM

And was my solution for your original question adequate?

**Sean Gillan** · 07-21-2014, 10:35 AM

It didn't work, the first combo box still contains everyone's name and not just the people on shift, then the second one was blank ???

I didn't understand the change you made t I am new to VBA and still trying to

**Sean Gillan** · 07-21-2014, 10:38 AM

Understand what you changed an how to complete it throughout my user form

Name Selection in a userform, To create a Signing In Sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Re: Name Selection in a userform, To create a Signing In Sheet.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] create hyperlink to another sheet when specific selection is made on a dropdown

Userform that duplicates Information and places in correct sheet depending on selection

guys i am trying to create a team selection sheet that has to do 3 teams

userform combobox fills from selection on sheet

Calculate total time worked from signing in and signing out

Bookmarks

Bookmarks

Posting Permissions