Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set cell values based on selection from list
I have a list of four options in a cell. I want to control a set of
destination cell values based on the user selection of the options from the list. As an example: option 1 sets the destination cell values to some numbers, where as option 2 may set the values of very same destination cells to some other numbers. When user selects an option from this list I want to do the following: 1) Initially reset the destination cells to zeroes 2) If user sets some values in those destination cells, I want to remember the user set destination cell values, as applicable to selected option and display it next time. I am sure this has been discussed and solved problem. I am new to this. Can someone give the right examples? Thanks Rao |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating values based on selection from a drop-down list in Exc | Excel Worksheet Functions | |||
List box change values based on selection | Excel Discussion (Misc queries) | |||
Excel - Sum of Values based on adjacent list selection | New Users to Excel | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Selection based on values in a cell | Excel Programming |