Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list box
Could I have some help on the following:-
I have a need to take the value that a user selects from a data validation list box and use this value in a case statement to populate an adjacent cell For example Data validation list box is triggered in cell A1 The user can selects from Red, Green, Black The result would then be read by a case statement. Case Red Cell B1 would then be filled with the value AA Case Green Cell B1 would then be filled with the value AB Case Black Cell B1 would then be filled with the value AC Cell B1 is then populated with the corresponding value If the list box in cell A2 was selected the result would be populated in B2 If the list box in cell A3 was selected the result would be populated in B3 And so on The list boxes will be in column A 1 to A200 this can be added to as the user adds more data. A201, A202 ……… |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list box
In B1:
=IF(A1="Red","AA",IF(A1="Green","AB",IF(A1="Black" ,"AC",""))) Copy down as far as you need. -- Ian -- wrote in message ... Could I have some help on the following:- I have a need to take the value that a user selects from a data validation list box and use this value in a case statement to populate an adjacent cell For example Data validation list box is triggered in cell A1 The user can selects from Red, Green, Black The result would then be read by a case statement. Case Red Cell B1 would then be filled with the value AA Case Green Cell B1 would then be filled with the value AB Case Black Cell B1 would then be filled with the value AC Cell B1 is then populated with the corresponding value If the list box in cell A2 was selected the result would be populated in B2 If the list box in cell A3 was selected the result would be populated in B3 And so on The list boxes will be in column A 1 to A200 this can be added to as the user adds more data. A201, A202 ... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list box
Ian
Just the job Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list box
Glad to help.
Thanks for the feedback. -- Ian -- wrote in message ... Ian Just the job Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
Crazy Data Validation ... List Validation Not Working | Excel Programming | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Programming |