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 ………