Run-time error '9' Help

[Pookiemeister]

On my userform I have two combo boxes and one read-only textbox. In the first text box the user selects a machine production line. Based on the machine production line selected, the second combo box will populate with the products that are ran on that line which is located on a spreadsheet named for that line. The problem that throws a "Run-time error '9': Subscript out of range" is when the user exits the first combobox and makes a selection from the second combobox and then decides to go back to the first combo box. The code that is highlighted when I select the Debug option is shown below.

By the way, the names associated with above boxes are:
First combobox Name=cmbSDPFLine
Second combobox Name=cmbPrdCde
Read Only Textbox Name=txtbxPrdctNm

Private Sub cmbPrdCde_Change()    
            Me.txtbxPrdctNm.Value = Replace(Split(Me.cmbPrdCde.Value, "(")(1), ")", vbNullString)

End Sub

Thank You.

NOTE: As long as the user continues through the form as normal and doesn't return back to the combo boxes, no error is thrown.

 

[Fluff]

How about

Private Sub cmbPrdCde_[COLOR=#0000ff]Click[/COLOR]()    
            Me.txtbxPrdctNm.Value = Replace(Split(Me.cmbPrdCde.Value, "(")(1), ")", vbNullString)

End Sub

As I originally suggested.

 

[Pookiemeister]

But I would have to put this code inside the click event in both combo boxes. Right?
Because if I add another textbox below the combo boxes, regardless of which combo box I click on, it still throws that error message.
I added another text box below the combo boxes to test and see which combo box threw the error code, but they both did.

 

[Pookiemeister]

After putting the code where you suggested, I still get the same error message.

 

[Fluff]

Did you remove the Change event?
Did you click cmbPrdCde while cmbPrdCde was empty?

 

[Pookiemeister]

No I didn't remove the change event and that was why it still gave that same error message. I found that out after I removed it and reran the code. Thanks again.

 

[Fluff]

You're welcome