For the Run-time error... If you put the cursor in the UserForm_Initialize sub and use the F8 key to step one line at a time through the code, you'll see where the problem is.
If you Open Name Manager from the Formulas ribbon and filter for Names with errors you'll see there's a 'refers to' issue with l_Emp
Thanks. F8 did show me in step where my issue is. l_Emp became invalid when I change the name format by splitting first and last name into separate columns after writing that line. It was the first code I wrote before i had an idea of what I want. Pretty dumb.