$$Excel-Macros$$ Userforms: 'Confirm' Scan vs 'Confirm' Button?

I have a simple userform with 2 textboxes for barcode scanned entries. Once the user confirms the entries are right, they click a “Confirm” button that drops the two entries into columns, then clears the textboxes. Where I’m seeking help is, instead of having the users click a “Confirm”

$$Excel-Macros$$ Help Required

Dear Excel Guru, I need help how to find out the list of name male or female, If Male adding infront of name (MR), If Female adding infront of name (Mrs). Please find attached the file for your reference. Kindly resolve the problem. Thanks in Advance. Thanks & Regards, Sriram G -- Are you =EX