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 (as many as 10,000 rows of data) for a clinical research trial.
I've developed a userform with a multipage control that has two tabs. However, the data on each of these tabs is to be entered at different times, so what I would like to do is set the comboboxes at the top of the second tab ("Image Interpretation") so that the correct patient can be identified and the data entered into the correct row. I have thought of two possible ways to do this, but I am not sure about how to go about doing either of these, or which would be the best way to go.
The first solution I thought of was to have the data on the first tab of the multipage control ("Patient Data") save to a separate worksheet, and to then program the userform so that it would automatically fill in the data for the patient (once it was identified using the comboboxes at the top of the second tab), so that it could be entered into a master worksheet with the data from the second tab.
My other idea was to program the "OK" command button on the second tab to automatically enter the data for the patient selected into the correct row.
I've attached a copy of what I have so far, in case that helps.
I already started a thread with a similar question, but I wasn't sure how to adapt the code that the users provided to fit my needs. I'm not sure how to link that thread to this one, but the title of the thread was "adding values to a combobox from a specific range of cells".
I really appreciate any help you all can give me!
Bookmarks