Rick,
You can place a ComboBox from the controls toolbox on your sheet,.
Select design mode then right click, Properties

In the Alphabetic list of Properties
Depending on what you want to return from the selection set the
BoundColumn 1 will be LastName
Make ColumnCount 3
You can play with the ColumnWidth for each part of the name perhaps
50,15,50
LinkedCell wherever you want the result output to
ListFillRange A1:C100 or however many
ListRows 10

You can do this as code, as well but if this would work for you it is
pretty simple.

Scott



On Thu, 21 Feb 2008 21:25:00 -0800, Rick
wrote:

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.