Contextures Order Form

[MAN@discussions.microsoft.com MAC MAN]

Hi,

I have been using your Order form for 1 year and it's great however I have
run into a little problem.

Up until July I was using the form on a PC but have since switched to Mac.

I bought the Office for Mac when I purchased my IMAC.

Everything has been running smoothly until this week when I tried to add
several new products to my ProductList.

When I use the dropdown box on the order form itself, it only scrolls down
to a certain point and stops.
I had 1034 product entries or lines and I have added another 300 or so
additional product entries or lines and when I scroll to get those, the
scroll bar stops at lin 1034.

Can you help ?

[Dave Peterson]

The version described here:
http://contextures.com/xlOrderForm01.html

I use xl2003 on a wintel machine, so take this with a grain of salt -- or try it
yourself.

I added data to the list in the Products worksheet and redefined the name to
include all 1500 cells (a2:a1501).

The data|validation dropdown on the order form worksheet showed all the entries.

So I'm guessing that it's either a problem with the name -- did you remember to
redefine the range to include those extra entries?

Or it's a difference in the way the Mac behaves.

You may want to post in
news://msnews.microsoft.com/microsoft.public.mac.office.excel

(Include the version of your OS, excel and anything else that may matter with
Mac's <vbg>.)

========
If it turns out that you forgot to redefine the range, you may want to redesign
your form. Scrolling through 1300 entries seems like a lot of work.

Debra shows a way to use dependent lists here:
http://contextures.com/xlDataVal02.html

You could define some prefixes/types in one data|validation dropdown that would
limit the choices in the second/dependent cell.

--

Dave Peterson

[MAC MAN]

I have been using this order form for over a year but recently changed from a
PC to Mac. I purchased the Office for mac software when I bought my computer
and everything was fine until I tried to add more products in my ProductList.

When I use my dropdown box on the order form I can only access about 1035
lines although my whole product List has about 1200 lines.

Can someone tell me what I might be doing wrong ? Would be much appreciated
as I have tried everything including starting a new order form

Thanks
Bob

[Dave Peterson]

Check your earlier post.

--

Dave Peterson