I have multiple user forms to add information into relating to a worksheet of client information.

There are over 100 separate fields to enter data into about these clients.

The information gathered and entered into the userform controls is optional depending on the decisions of the user.

Each client has a unique six number identification number. I have a VLookup function that displays the clients name, address, age, date of registration and date of next scheduled review upon typing the six digit identification number into the first text box of the main user form from which all other forms are linked. Each form has a command button linking to the next userform if it is applicable to the users choice.


At present I am using a single form with multi tabs, but the forms are extremely crowded.

How can the output of the Vlookup function be placed within a textbox on all separate forms after the identification number is placed in just the first main user form.

Thanks,

Jack.