Inputing into Cell creates Command button (or alternative) on userform

Hi everyone, hopefully I'm following forum rules correctly but if not the please move topic/let me know and I'll make sure I follow them properly!

To the problem!

I am attempting to create a database of participant information that can be accessed by the team at the charity I work for, I am no-where near creating the whole database at this point but am trying to create the parts to use within it. I'm also using these tasks to help me learn VB in the hope that when I come to put all the parts together to create the database I will have a vague idea of what I am doing.

Anywho, thus far I have used information and tutorials from the web to create a button on a worksheet which takes the user to a userform which asks for participant information (first, surname, address, etc).

Once this data is entered into the userform it is sent to the registration worksheet while the firstname and surname are also sent to the signin sheet. Now here comes my problem.

I would like another userform (signin) that when opened will have the names that have been entered into the signin available as commandbuttons or similar, that when clicked on will turn Green to show that they have been signed in. When the user form is saved-(data sent to worksheet) I would like the date the userform was saved to show up along the top of the worksheet and a mark under it to show who was present on that day along with a total.

Now that I write that out it sounds like a lot. My Current test Workbook is attached and I have attached a screen shot of the userform interface idea for the signin sheet.

Any help is much appreciated or any directions to tutorials etc that cover that sort of things would also be great (cells creating buttons doesn't seem to come up often)

Thanks for looking!

Hi jaslake and mikerickson thank you for getting back to me!

jaslake - That looks like it would do what I'm looking for but I don't have a set number of participants. The chances are no group will be more than 25 but is there a way to make it extend as new ones are added? Also I'm getting run-time error 91 when I try and run it I've attached a screen shot, I've peered at it for a while but yeah I'm no where near being able to debug anything.

mikerickson - I can't get the code you put up to do anything although I imagine that's because I'm putting it in the wrong places.

To give you a bit more background, the idea is that different people who run the different groups within the charity will use their own sign-in sheet for their group and they'll do so using a tablet.
So for example lets say there is 3 groups.
When group 1 is in for their activity the leader would switch the tablet on and press/click on the "Group 1" worksheet button on the tablets desktop. This would open a worksheet that has a 'signin' button and a 'add to register' button for group 1 (the register itself and other info will be set to hidden).
They will then click on the signin userform button.
As participants come in they will click on their name showing they are in and if any new members turn up they can click on the register button get the details of off the participant and enter them into the register. Then the signin sheet will update with the new participant on it.

So at the moment I'm thinking each group would have their own set of worksheets but then all of the data would also go to 2 over all worksheets, 1 with all of the registered users that go to all activities and 1 which has participation numbers.

So basically I thought having the names come up as command buttons would be the best way to keep it simple for the people who will be using the user interface. Does that make sense?
I'm definitely open to other ideas though if anyone has a better way of doing this? and I would definitely try different things too.

Thanks again you two it is very much appreciated. Attachment 441350

Thanks Norie, I'd be happy with a list box, if people think that's the best way to go. Where would I place the code mikerickson put up? Hopefully it attaches ok this time runtime error.jpg