Creating an Order Form....Ragdyer & anyone else?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


I can't get back to my thread for some reason, and since it's your order
form Rag, I am hoping you or someone can help me again...

Here's the things I need to do and can't seem to figure it out...

1. On the drop down list, some of the description list are very long,
they have to sometimes choose 100 items, I would like the customer to
be able to type in a few letters and have the closest item come up...i
thought it was auto complete but must not be because it doesn't work
for me.

2. How do I make a column recognize the next pattern and complete it. I
haven't done this in ages and I have tried several ways but it wants to
go to the next cells as =A2 =A3 =A4 instead of F1 G1 H1 etc.

=A1
=B1
=C1
=D1
=E1


3. How can I make it where Column 1 if changed will clear out column 2
on the order form to start over, because if I select a different
category than previously selected, it will let me keep the wrong
description for that category unless i tab over and change it too.

An Example...

Selecting Category "pens" then description retractible, then change my
mind and decide to enter markers, it keeps retractable until I change
it, even though retractible is not an item for markers.

Thanks in advance! The order form looks awesome!

KL


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23841
View this thread: http://www.excelforum.com/showthread.php?threadid=375089

.

Relevant Pages

  • Re: OT:Thanksgiving
    ... This is an honest question: since most states DO have such an ... figure out just what that reason might be. ... While men were the primary hunters, women were the primary gatherers; ... It's not really such a great leap from "selecting the best nutritional value ...
    (comp.lang.cobol)
  • Re: Upgrade Anxiety
    ... There was a bad reason: the very weak ClassWizard ... New markers can be added, and new versions will use those markers. ... Yes, but to do otherwise would have required DESIGN, something woefully absent. ...
    (microsoft.public.vc.mfc)
  • Re: Creating an Order Form....Ragdyer & anyone else?
    ... There are instructions here for using a combobox to overlay a cell ... form Rag, I am hoping you or someone can help me again... ... thought it was auto complete but must not be because it doesn't work ... even though retractible is not an item for markers. ...
    (microsoft.public.excel.misc)
  • Re: Help testing an idea required
    ... Maybe my imagination. ... that's the reason I selected it. ... the program I use to create the images doesn't allow selecting an order to overlay them. ... It's a totally random order. ...
    (uk.people.silversurfers)
  • Re: if the else short form
    ... boolean expression, which evaluates to True or False, but if you force a ... writing 'True == 1' on the Python interpreter to see what I mean. ... code snippet is creating a tuple with two elements, and then selecting the ...
    (comp.lang.python)