I have a user form with a combobox containing a list of names and the users have items that have been given a barcode label with a name. They scan the label and it selects the corresponding name from the list.
This is working fine with names but I want to shift to using an ID number rather than a name to protect identities and this is where everything falls down. When I scan the number it doesn't 'jump' to that item in the list but selects the first item in the list.
Does anyone have any ideas/suggestions why this would happen?
The combobox list is populated (in both cases) with:
ComboBoxTest.List = Sheet2.Range("StaffID").Value
This is working fine with names but I want to shift to using an ID number rather than a name to protect identities and this is where everything falls down. When I scan the number it doesn't 'jump' to that item in the list but selects the first item in the list.
Does anyone have any ideas/suggestions why this would happen?
The combobox list is populated (in both cases) with:
ComboBoxTest.List = Sheet2.Range("StaffID").Value