Userform - Number of text boxes depends on what user enters

**Vaish18** · 02-02-2015, 11:37 AM

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

**Arkadi** · 02-02-2015, 01:08 PM

Do you obtain the number of zones before the userform starts? Or is it an existing textbox? You could use the change event of the zones textbox to generate new textboxes once the value of the zones text box changes?

Edit: I take that back... perhaps the exit even is better, since typing the first digit of a 2-digit number would trigger the change macro.

**Arkadi** · 02-02-2015, 01:20 PM

Vaishin, my suggestion would be to get the number of zones during the form initialization as an input box prompt, and then dynamically generate the textboxes from that anwer. Something like this?

Please Login or Register  to view this content.

Userform - Number of text boxes depends on what user enters

LinkBack

Thread Tools

Rate This Thread

Display

Userform - Number of text boxes depends on what user enters

Re: Userform - Number of text boxes depends on what user enters

Re: Userform - Number of text boxes depends on what user enters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add number of text boxes inside a UserForm

[SOLVED] Make user enter data into one of two text boxes in a userform

[SOLVED] How to pop up message when user enters any text in TextBox. Should be enter by number only

Check for Duplicates when user enters values in the UserForm

userform, label text display value depends on user input

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions