Keeping track of groups

[DJDJDJDJ]

Hi,



I am trying to find a way to keep track of groups of students. Essentially, I have a set number of students in a class. There are 5 (or 6) groups in a class. Each student can be member of exactly one group.

Ideally, I would like either drag-n-drop or use a button to simply add/remove students from groups. I have attached a sample (non-working) of the image I have in my mind. At this time, I don't any ideas about how to go about implementing this so I am open to ideas. If you think there is a better way to do this, I am open to it. Main goal is to keep track of groups and have an easy way to see who is in which group and move them around if needed.

Thank you in advance.

[June7]

Can use listboxes and VBA code. The code can either change listbox RowSource query or use AddItems method.