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.