maybe someone else has another way, but this is just using formulas.

i used a helper column to concatenate the names, column d in this instance.
so, in a2:
=B2&" "& C2 &" "&A2
and auto filled down

then create a named range using a dynamic range:
i named it employees and entered this in the refers to box:
=OFFSET(Sheet1!$D$2,0,0,COUNTA(Sheet1!$D:$D),1)

then in the combobox, i'm assuming it's on the sheet and not in a form,
enter this into the input box on the control tab:
employees

--

Gary


"Rick" wrote in message
...
I have a Accounts sheet that contains the following:
Col-A = Last Name
Col-B = First Name
Col-C = M.I.

I want to load a combo_box on the Invoice sheet with data from all 3
columns
and up to 10 rows.

Can you help me with the code.