Names subtracting after they have already been selected in another combobox.

Hi,

Yes indeed. There are no doubt several ways. Off the top of my head the approach I'd probably use is to have a second list of names that is covered by a dynamic range name.

At the start of your process then copy the main list of names to the column containing the dynamic range name, and use this dynamic range name as the RowSource property for the comboxes. Then each time you select a name in the combobox, use a Find instruction to find that name in the dynamic range and delete that cell moving all the other names upwards.

Hello Sean Gillan,

There are other ways to accomplish what you want. To find out which method will work best, you should post a copy of your workbook.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

Hi,

Why is it necessary to have 28 combo boxes for people to sign in?

Surely four boxes is sufficient since you can only handle one name at a time? After that name has been updated to the system then use the same 4 boxes again (with the names showing one fewer as I mentioned).

Hi,

I still don't see why you NEED 28 sets of comboboxes. Your code is unnecessarily complicated having to handle all 28. At the moment it seems the only thing the different boxes are doing is positioning the sign in details at a particular position on the sign in sheet. Why not just add each sign in to the next available space on the sign in table and use a check cell to tell when all 28 are filled and reject any more additions.

If you need to correct an entry just use the same 4 combo boxes but have a 'correction' button which populates the combo boxes with the values for the name selected and either deletes that line moving all others up or edits the 4 entries on the table.

Just because you have spent a lot of time getting to where you are, don't be too proud to accept that there is still a better way. Believe me I've been there too many times and got so many T shirts I could open a stall on the local market. It seems to me that this is typical of a development process. Two steps back, reviewing and coming up with a neater way forward seems to be common. And if there isn't already a named 'law' for this phenomenon then it's about time there was.