jsneak
11-18-2013, 09:44 AM
Afternoon all,
Is this even possible?! I'm quite new to VBA in excel and I was wondering if something like this was possible in a userform? I've tried all kinds of things and i've got nowhere near what i want :rofl:
I currently have a userform setup. The ComboBox holds the data that the user would select and next to it are 7 (Each day of the week) textbox's which i'd like the user to manually enter into (These would be names) Each TextBox is assigned that days tag.
In the attached file, the yellow cells are an example - So once the userform is opened, the user would select 07SA001 (From the ComboBox) and enter names in Tue-Wed-Thu-Fri-Sat and then click "Add names" Which would add the names to that duty for the correct day.
(I'm not sure if a ListBox instead of a ComboBox would be better either?!)
Sorry if I haven't explained this clearly, however the attached file should help!
Any help on this matter would be great, thanks!
10843
Is this even possible?! I'm quite new to VBA in excel and I was wondering if something like this was possible in a userform? I've tried all kinds of things and i've got nowhere near what i want :rofl:
I currently have a userform setup. The ComboBox holds the data that the user would select and next to it are 7 (Each day of the week) textbox's which i'd like the user to manually enter into (These would be names) Each TextBox is assigned that days tag.
In the attached file, the yellow cells are an example - So once the userform is opened, the user would select 07SA001 (From the ComboBox) and enter names in Tue-Wed-Thu-Fri-Sat and then click "Add names" Which would add the names to that duty for the correct day.
(I'm not sure if a ListBox instead of a ComboBox would be better either?!)
Sorry if I haven't explained this clearly, however the attached file should help!
Any help on this matter would be great, thanks!
10843