Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cell base on free form or standard inputs.
I am using a validation list as my primary selection (Part Family)
then a 2nd validation (base off family) for my sub list (Part Type). Base on the data selected from “Family” and “Type” there are 2 to 12 attributes required. Most of the attributes are free form, but, some are standard. I would like to format the “Standard” cell to have validation list added. I am working with 36 Primary selections, 1 to 10 secondary selections, and 2 to 12 attributes. I started with IF’s it getting to be un- manageable. Can some recommend a different approach? Also, was told that and array is the way to go, but, I have never used array before… Can some one help??? Thanks you in advance for any and all help with this matter… |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cell base on free form or standard inputs.
G'day Bob
I suggest you use a combobox and lay it over the cell in question, that way you can pull the data from the combobox or enter it manually. Data validation lists won't allow you to do this, which will suit standard inputs. Try Debra Dalgliesh's website www.contextures.com She has a really good section on Multiple Data validations. HTH Mark. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to free-form textboxes | Excel Programming | |||
Conditional Formatting for 6 inputs | Excel Discussion (Misc queries) | |||
Standard Deviation do I use 520 (20x26) inputs or avg of each | Excel Worksheet Functions | |||
standard form | Excel Discussion (Misc queries) |