Type mismatch problem

I am completely new to VBA and am trying to create a user form that will fill-in TextBoxes dependent on the value of ComboBoxes.

We have a dozen or so separate workbooks which this form will be placed in for data entry purposes.

The source of the data ranges for the ComboBoxes and TextBoxes is being kept in a separate workbook for ease in updating and editing the data.

I am getting an error msg:

Run-time error '-2147352571 (80020005)':
"Could not set the property value. Type mismatch"

When I click on Debug this is the line that becomes highlighted:

Please Login or Register  to view this content.

I have tried everything I could find googling this error,
changing the ListItem As Variant, i As Integer to i As Variant;
taking out the ListItem As Variant, i As Integer line all together;
adding a line with Textbox() As Variant...(Like I said, I am extremely new to VBA)..

When I look at the cells in both excel sheets - the cells are all "formatted" as General, so I am not sure what their data type is ...?

I REALLY would appreciate any suggestions..... PLEASE HELP!!

This is my code -

Please Login or Register  to view this content.

Dave and Roy,

Thank you both so much for responding to my plea for help!

Roy I used:

Please Login or Register  to view this content.

and it seems to be working like a charm!!
Here's what it looks like now:

Please Login or Register  to view this content.

I need to do the same thing for 10 more pairs of ComboBoxes/TextBoxes - will having that many cause any problems do you think?

Once again, thank you both - it is truly appreciated!
Bernadette