Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Cell Value Based on List selection
Okay, I added a list to my excel workshet and I need to change the value of
an adjacent cell based on what is selected from the list. Example: Cell B2 of worksheet 1 contains a list formed from cells A1, A2, A3, A4 on the 2nd page of the worksheet. When item 2 "A" is seleced from the list in cell B2, cell B3 must change from the default or current value (whatever that may be) to "Zebra", when item 3 "B" is selected from the list i Cell B2 of worksheet 1, Cell B3 of worksheet 1 must change from the default or current value (whatever that may be) to "Horse"...and so on and so forth. Conditional formatting will not work. Any and all suggestions are greatfully appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best method to populate cell based upon drop down list selection | Excel Discussion (Misc queries) | |||
How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
How do I enter data in an adjacent cell based on a list selection? | Excel Worksheet Functions | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Macro to change list box input range based on selection made in another cell | Excel Programming |