Populating a userform based on a range of 3 columns

**JimmyA** · 03-02-2012, 08:50 AM

Hello All

I have attached a spreadsheet to show what I am trying to achieve in terms of look and functionality but I am not 100% sure if text boxes would be the best way to do it.

The number of rows would be dictated by values in column “A” (which can change). The intention is that the userform would populate the values available and the user could then populate the missing information on the userform. The “Code” would always be populated; there would never be a blank in Column A.

If I have made any sense, I wonder if someone could point me in the right direction in terms of whether textboxes are the correct way to go and if not what I should be looking at.

If text boxes are the best way to go, is it possible to add them to the userform based on the number of records in column A?

Thanks in advance for any help or suggestions.

Regards
Jim

**royUK** · 03-02-2012, 09:58 AM

Use the form's ControlSource Property

**JimmyA** · 03-02-2012, 10:27 AM

Thanks very much for this Royuk it is really helpfull.

As the number of rows in the sheet could change is it possible to automatically add and remove the text boxes or would that not be practical? Do you know if it is possible to place part of a sheet into a userform?

Thanks again for your help

Regards

Jim

**royUK** · 03-02-2012, 11:29 AM

You can add Textboxes programmatically but it's not easy. Why not use a ListBox & populate TextBoxes based on the user's selection?

**JimmyA** · 03-02-2012, 12:41 PM

Thanks again Roy

I think I may have to have a re-think, I am hoping to have the userform populated with the available data (as per the example) and for the user to key in missing values. The data will provide all of the Code labels (Column A) but the min and max values may not always be there. So rather than the end user populating all of them I was hoping that they could just be given the available data to check and add any missing min and max values.

Thanks again for your help

Jim