I use validation drop down dialogue boxes in Excel 2000 to fill in purchase
orders from an existing list of products. This works fine for the most part
but I have a few questions. I have close to 1000 products on my list. When I
use the drop down box to fill in my forms, the box is too small or too
sensitive. With the list being that long, the data displayed in the box tends
to jump around when I scroll, page up or page down. I feel that if the box
could be made longer, the data would be more stable and easier to access. Is
this possible?

It appears to me that my validation list is only ever available to be
referenced when it's included in the workbook I'm working in. This leads to
multiple copies and problems with keeping them all current. I'd like to have
one copy of the list and be able to reference it in any workbook that I
choose to work in. Is this possible?

Thank You,

Paul Staley

Paul,

It can be done temporarily as described here
http://www.contextures.com/xlDataVal08.html#Wider, and larger,
http://www.contextures.com/xlDataVal08.html#Larger

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sahadev" wrote in message
...
I use validation drop down dialogue boxes in Excel 2000 to fill in
purchase
orders from an existing list of products. This works fine for the most
part
but I have a few questions. I have close to 1000 products on my list. When
I
use the drop down box to fill in my forms, the box is too small or too
sensitive. With the list being that long, the data displayed in the box
tends
to jump around when I scroll, page up or page down. I feel that if the box
could be made longer, the data would be more stable and easier to access.
Is
this possible?

It appears to me that my validation list is only ever available to be
referenced when it's included in the workbook I'm working in. This leads
to
multiple copies and problems with keeping them all current. I'd like to
have
one copy of the list and be able to reference it in any workbook that I
choose to work in. Is this possible?

Thank You,

Paul Staley

Bob,

Thanks for the reply. My computer went down so I wasn't able to give it a
try till today. It hasn't actually worked just yet, but I will give it
another try tomorrow at work.

Again thanks for the helpful lead.

Thank You,

Paul Staley

Well post back if you still have problems.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sahadev" wrote in message
...

Bob,

Thanks for the reply. My computer went down so I wasn't able to give it a
try till today. It hasn't actually worked just yet, but I will give it
another try tomorrow at work.

Again thanks for the helpful lead.

Thank You,

Paul Staley