Excel: Adding multiple values to a combo box based off of a value in another cell


Hello I have a userform dumping data into an excel table. I'd like for a user to be able to select their name and have a list of their records populate in a record ID combo box. I wrote the following code that seems to almost be doing what I need, except that it is pulling all of the record ID's in the table not just the ones that match the cboStaff.value ? Private Sub cboStaff_Change() Dim x As Range Set rng = Worksheets("CorporateCoordination").Range("TableCorpCoord[Staff]") Set x = Worksheets("CorporateCoordination").Range("TableCorpCoord[Staff]").Find(What:=cboStaff.Value, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=True) On Error GoTo 0 For Each x In rng With cboRecordId .AddItem x.Offset(, 1).Value End With Next x End Sub Could someone help me understand where I have misstepped here? The items are names so do I need to be declaring something as a string to help in the find operation? The userform is the only way staff can enter their names so I don't think its a MatchCase issue.. Thanks


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of April 12, 2018.


For more resources for Microsoft Excel