Another problem has surfaced in our user form. As shown, the default user form only has one name and designation to fill in, keeping things simple. However, as this form is on excel, adding names and designations would be highly impossible if the user so required.

This was a problem that even the functions on excel were unable to solve and as such, we had to rely on our proficiency on VBA macros programming. to achieve the following.

We made it such that when the user entered the number of names, the corresponding number of boxes would appear for the user to fill in.

Thus, when the user enters 3 names, 3 boxes would appear and if he enters 5, 5 boxes would appear.

However, we had to decide on a limit of numbers the user can input.

The code for the above is as so.

Complicated eh?