Can someone please translate this worksheet formula to vba code?

=NameList,INDEX(NameColumn,MATCH(A2,BadgeColumn,0) )

The formula does what I need it to do, but I am trying to create a
userform with comboxes and need the second combobox to do this based on
information supplied in the first combobox.

Thank you in advance!