Compile error help

[Pookiemeister]

Private Sub cmbSDPFLine_Enter()    Dim i As Long
    
    cmbSDPFLine.Clear
    cmbPrdCde.Enabled = False
    cmbPrdCde.Clear
    txtbxPrdctNm.Text = ""
    
    WS_Count = ActiveWorkbook.Worksheets.Count
    
    For i = 4 To WS_Count
        cmbSDPFLine.AddItem Sheets(i).Name
    Next
End Sub

As of now I have four sheets with the names of the different machines at our packaging facility. The above code populates a combo box called cmbSDPFLine with those sheet tab names of the machines.
On my userform I have two combo boxes. The first one is the one above mentioned. The other combo box is called cmbPrdCode which the Enabled is set to False until cmbSDPFLine contains a value. This part of the code is located in cmbSDPFLine Change.

if cmbsdpfline.Value=cmbSDPFLine.AddItem Sheets(i).Name then

The error that I am getting above is a "Compile error: Expected: Then or GoTo" and for whatever reason I am also getting another error "Compile error: Syntax error".

if cmbsdpfline.Value=cmbSDPFLine.AddItem Sheets(i).Name then    
cmbPrdCde.Enabled = True
End If

The above code is what I want to happen. Not sure if it will work.
What I want to achieve is if the cmbsdpfline value is equal to any of the machine sheet names that starts on sheet four, then enable cmbPrdCde combo box. Thank You for any help offered.

 

[Fluff]

How about

If Len(cmbsdpfline.Value) > 0 Then cmbPrdCde.Enabled = True

 

[AlphaFrog]

What I want to achieve is if the cmbsdpfline value is equal to any of the machine sheet names that starts on sheet four, then enable cmbPrdCde combo box. Thank You for any help offered.

Try this...

Private Sub cmbSDPFLine_Change()
    cmbPrdCde.Enabled = cmbsdpfline.ListIndex > -1
End Sub

 

[Pookiemeister]

Thank you for the quick response. So basically if the length of the value inside cmbSDPFLine is greater than 0 or is not empty then cmbPrdCde is enabled. If that is correct, than thats so simple. Thank You very much.

After I tested that code. It worked. Thank You.

 

[Fluff]

Glad we could help & thanks for the feedback