OK. I assumed that you were using a drop down list which you put onto a
worksheet using the Forms toolbar. Once placed on the sheet, right-click and
choose "Format Contol" on the Control tab

"Marlis" wrote:

how do I format the control

"bigwheel" wrote:

When you format the control use something like [customer.xls]Sheet1!$A$3:$A$5
as the input range

"Marlis" wrote:

I am trying to create a drop down list that allows me to insert the name and
address of a customer. My customer list is in a seperate worksheet.