LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Data validation list decreases as the user chooses from the list/s

I am trying to create a validation list in Excel 2003 with two or more
sub-lists. For example, the first validatation list contains 4 options. Each
option has sub-options. And each sub-option has sub-options also. I would
like to accomplish a list that when the user select 1 option from the main
list it will only show its sub-options. And as you select the sub-option it
will show the sub-sub-options.
Find below the illustration

List:
Actions = 4 sublists = each sublist = 10 sublists
Conditions = 4 sublists =each sublist = 10 sublists
Personal Factors = 5 sublists =each sublist = 10 sublists
Job Factors = 9 sublists =each sublist = 10 sublists

Example:

Actions
l--- Following procedures
l---- Individual, Group, Supervision, Improper loading, etc.

l--- Use of Tools or Equipment
l--- Use of Tools, Use of Equipment, Use of Defective
Tools, etc.

And so on, so forth.

Hope you can help me with my problem.

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING Bellyjean Excel Worksheet Functions 1 March 7th 08 09:46 PM
data validation list: how do i 'force' a user to enter data from the list? showsomeidnow Excel Discussion (Misc queries) 4 May 1st 07 05:49 PM
data validation list: how do i 'force' a user to enter data from the list? showsomeidnow Excel Discussion (Misc queries) 2 April 29th 07 11:09 PM
Validation list that also allows user entry? Angela Dennis 911 Excel Worksheet Functions 6 July 20th 06 02:33 PM
Data Validation - List - keeping the format of the list - shading aasbury Excel Discussion (Misc queries) 1 June 5th 06 04:25 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"