Ken,

It certainly sounds like you're trying to use data validation droplist, not
a "real" list box drawn from either the Forms toolbar or the Control
Toolbox, which I had earlier presumed was your subject.

Try Debra Dalgleish's good coverage on the steps for data validation (DV) at
her:
http://www.contextures.com/xlDataVal01.html

The DV technique is, as per Barb's response to you, to use a named range eg:
MyList housing all your 201 items, then to put it in the DV's Source:
=MyList (instead of keying in all the individual items into the Source box
itself). Try Debra's page, where she explains and illustrates the steps very
well. I'm pretty sure you'd be able get it up and going in a short time.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ken Williams" wrote in message
...
Hi Max,
Guess I'm just not getting this. I am brand new to Excel. The only way I
know to try this is to Data/Valadition/Select LIST then fill the numbers
into the Source window. I am only permitted to enter 40 numbers into the
box. I can't figure out how to use the Forms to create a list box.
Thanks,
Ken