Hi All
I've designed a form (attached) to complete a rota spreadsheet, which uses identical ListBox(es) for rota tasks/times. I have a single list box for names and I can populate each ShiftList using an array. It would've have been neater if I could have used ShiftListX, with X being a numeric variable to cycle through the 7 days of the week, ShiftLIst1, ShiftList2, etc. However, that didn't work, so I've had to replicate any code for each of the days, i.e. ListBoxes. Surely there must be a neater method to work with these ListBoxes, when they are treated exactly the same way.
I did think about reducing it to a single day and using the form 7 times instead of once.
My code works but it is so longwinded and I'm struggling to find an easier/less verbose way to do it. Any ideas?
Many thanks in advance.
Bookmarks