Userform DropDown Filled based on Entry

**SOLVED
Answer in reply 12, Thank you again so much!!**



materials userform.png

Hi guys, new here.
I've been figuring out excel and vba on my own for a minute but this has me completely stumped.
I want it so that when I enter an value in the "AC#" text box and click the "show materials" button, it will load a list of up to 5 materials from a separate sheet via vlookup.
I can't even get it to give me one item via this method let alone 5.

Private Sub ShowM_Click()
If WorksheetFunction.CountIf(Sheets("List").Range("A:A"), Me.AC.Value) = 0 Then
MsgBox "This AC is not Added"
Me.AC.Value = ""
Exit Sub
End If
With Me
Me.PN.Text = Application.VLookup(Me.AC.Text, Sheets("List").Range("a:C"), 2, 0)
End With
End Sub

Is what i have tried most recently. I also tried one using Find but couldn't get it to work either.

I've never posted to one of these so please correct me if there is anything that I am doing wrong.


** Worth noting that the pop up that scans for the value does work, if the value is not listed it will pop up. But if it is listed the error comes at the vlookup area **