Good morning,
I have created a VBA userform to add details for students in school. Each time I add a new student, I have to then fill each box with their details - year, form etc. Is there a way to automatically fill more than one box from a selection? So for example, if I select James Smith A3, it would then add B3 (year) and B4 (B4) into the right boxes. If you could sign post me to a video and I'll try to work it out from there. I am not sure what this is called so I have not had any luck searching for an example.
Thanks!
I have created a VBA userform to add details for students in school. Each time I add a new student, I have to then fill each box with their details - year, form etc. Is there a way to automatically fill more than one box from a selection? So for example, if I select James Smith A3, it would then add B3 (year) and B4 (B4) into the right boxes. If you could sign post me to a video and I'll try to work it out from there. I am not sure what this is called so I have not had any luck searching for an example.
Thanks!