Source Data for Combo Boxes

[Skelly022782]

Hi

I'm new to the forums

I'm just picking up VBA now and had a question I'm hoping someone could shed some light on.

I'm trying to create a workbook for tracking costs and change orders for multiple subcontractors.

My main question is about combo boxes. I would like to create a master list of subcontractors on The masterlists tab of the attached workbook. I would like to use this masterlist as the data source for a combo box I'm going to use to replace the subcontractor txtbox on the SubCoEntryFrm.

I figured getting away from a user typing something in would benefit me if I wanted to use that subcontractor name field to analyze data

Any thoughts? I've attached the workbook to the post.

Thanks,