Hello.

I am creating a VBA tool for a company. For them to be able to easily use the tool, I am using a Userform.

I have asked for the user to enter how many zones they have in a building which is a numeric value. How then can I either get the Userform to generate the number of text boxes that the user has inputted in the question above?

If not on the userform, how do I get the spreadsheet to then only show the number of rows that the user has defined.

I also wanted the user to to provide a matrix in order to understand what rooms are adjacent to one another. Is there an easy way for this to be incorporated on the userform?

Any help you can provide would be much appreciated.


Vaish