in the VBA window, on the properties sheet for this combo box, there is
a field named "RowSource" simply type in this field the name of the
list of data you want the combobox to contain

eg. if the combobox should call upon a list of names somewhere in the
workbook defined as FirstName
type that into the RowSource field on the properties.

if it is only the three names, and won't be changing on the sheets, you
can (i think, never actually done it) just type the options into the
RowSource field, in " " and seperated by ;

eg. RowSource "Dan";"Sarah";"Cara"
not sure if this will work, but might as well try

Hope This Helps

Cheers,
Dan

=P