Master Child in VBA userform

[shawnw]

I have two worksheets:

- "People" (shows unique salesperson ID, name, and basic info about our sales team members, with one row per salesperson)
- "Sales" (shows details about each sale, with a foreign key back to the salesperson ID, with multiple rows per salesperson).

I have a VBA userform that lets users view and modify the salesperson data in the "People" worksheet. I would like to show zero to N rows at the bottom of the same userform and also display the data from the related "Sales" worksheet.

Basically, i want to show the salesperson at the top and their sales at the bottom of the same userform. I want to keep them synchronized. And I want the user to be able to make edits.

Is this possible in Excel?

Thanks,

Shawn

 

[shawnw]

Yes, this is basically what I want. Since we can't put in a subform, we could just display maybe 5 rows of child records and have a NEXT and PREV buttons to show the following or previous set of five. I can't use listboxes or comboboxes, because I want all the form data (master salesperson records and child sales records) editable. Thanks!