Add data from a userform to a specific row

**blindzero678** · 07-08-2010, 06:14 PM

I am new to using VBA, and this is the first userform I have ever made. I'm trying to build a database of a lot of data for a clinical research trial.

I have been able to get the userform to add the data to the worksheet. However, the issue I came across is that I cannot fit every entry field onto one userform, so I had to split it into two forms. I added an entry field in the second form to identify the patients as well, so I would be able to match the data from the two forms, but I do not know how to get the data from this form to be added to the same row as the data from the first form. So I guess my question is, is there a way to have the userform add the data into a specific row (ie, a row that already contains a specific entry in a specific cell?)

While I was trying to find an answer to this problem, I came up with an alternative. I was thinking that I could have the two userforms add their data into two separate worksheets, then program a macro to copy this data into one master worksheet. would this be easier? if so, how would i go about doing this?

I really appreciate any help you all can give me!

**blindzero678** · 07-08-2010, 08:02 PM

I can definitely see how that would work. Would using the MultiPage object affect how I write the code for the objects on the form?

**Leith Ross** · 07-08-2010, 08:05 PM

Hello blindzero678,

The effects will be minimal. Check your VBA help files for more information and examples.

**blindzero678** · 07-08-2010, 08:15 PM

Okay, thank you!!

**Leith Ross** · 07-08-2010, 07:48 PM

Hello blindzero678,

Instead of creating multiple UserForms, add a MultiPage object to your UserForm. The control has pages that can hold controls just like the UserForm. Each tab can be used to group like information together an make it easier for the user to find and edit the data. The MultiPage is part of the standard Controls for a UserForm.