Populating a UserForm

**j_Southern** · 03-18-2011, 10:54 AM

Dear Forum Members,
I need to be able to populate the controls in a userform from the values of the controls of a second userform.
I have used code like

Please Login or Register  to view this content.

The problem is that there are 16 textboxes and other controls on the forms and I am sure that there is a more elegant way of coding this .
Can anyone give me a suggestion please?
John

**MarvinP** · 03-18-2011, 11:01 AM

Hi,
The answer is you need to use the index number of the controls on your userform in a loop.

Look at http://spreadsheetpage.com/index.php/tip/C29 and search down for:
Handle Multiple Userform Buttons With One Subroutine
to see an example of indexing.

**royUK** · 03-18-2011, 11:19 AM

Why two UserForms? Is it really necessary?

See this example, each user form has two textboxes tb1 & tb2

**j_Southern** · 03-18-2011, 11:40 AM

Thanks for your help. I think I will be able to take it further now.
The two forms are connected with order entry. One accepts a new job name into a text box and is populated manualy. the other enables a search of existing job names and is populated by the program from data in the file of the existing job.
Sometimes an existing job needs a modification and in this case it is useful to populate the userform programaticaly and make modifications. This is where one form needs populating from the other form
John

**royUK** · 03-18-2011, 11:45 AM

Without seeing an example of the data i would have thought one Userform should be enough.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save