Consider using a Data Validation Dropdown.

http://www.contextures.com/xlDataVal01.html
--
Gary''s Student - gsnu200810


"klafert" wrote:

I am creating a form in Excel and need a drop down list. The data is coming
from another file. Actual an export from another program, a .csv file. I
may be updated now and then. How do I create a drop down box so, I can
choose entries from the .csv. I will have two possible three. Most I will
choose one choice, like customer names, but on choice will be a ship to
address. So, it will pull up a whole address.